Follow me !
By PDGACO GaballaLoans
Search this blog
-
Recent posts
Tags
AIX Apple automation backup best practices Bootcamp cloud cursor db2 db2 compression db2 hadr db2 performance db2 tuning db2 v9.5 db2 v9.7 db2move db2pd google indexes install iPad iPhone linux Macbook memory NULLID Oracle package performance restore runstats script shell script sql SQL805N SQL Server stored procedure tablespace time machine tuning ubuntu ubuntu 9.04 upgrade Windows on Mac wordpressDisclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Tag Archives: SQL Server
Denali is on its way !
Microsoft is coming out with a new version of SQL Server , codenamed ‘Denali’ a.k.a SQL Server 2012. It boasts lot of new features. I am not going to repeat all of them here now. Go to Microsoft to see all the … Continue reading
Posted in database, sql server
Tagged Always on, denali, MS SQL, MS SQL Server, SQL Server, sql server 2012
Leave a comment
Stored Proc for SQL Server and DB2 UDB
We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a quick stored procedure that will take couple of input parameter and run the grant against the tables. Just for the … Continue reading
Posted in database, db2, sql server
Tagged db2, dynamic sql, execute, grant, loop, sp_executeSQL, SQL Server, SQL/PL, stored procedure, T-SQL
Leave a comment
Setting up database mail in SQL server
Wouldn’t it be cool if your database server reached out to you when it wants to let you know something like a job that completed or failed and error messages its getting ? SQL Server has two built-in ways to … Continue reading
Posted in database, how to, internet, sql server
Tagged configure database mail, configure sql server mail, database mail, emailing from sql server, emailing from your database, sending emails from sql server, setting up database mail, SQL Server, SQL Server Agent emails, sql server email, sql server job failure notifications, sql server notifications, SQLMail
Leave a comment
Azure Clouds bringing database showers
My previous post talked about cloud in general. Here I like to talk about databases on the cloud. Just like emails, documents, CRMs and so on cloud computing providers has made database engines available on the cloud as part of SaaS. … Continue reading