This post is the second part of a two-part series on techniques for writing stored procedures. I’ve been mulling over this topic for some time, writing notes on occasion and trying to put some order around this topic… What I’d like to convey is not so much the “syntax” of writing stored procedures, but some… Continue reading Stored Procedure Techniques – Batch
This post is (hopefully) part one of a two-part series on techniques for writing stored procedures. I’ve been mulling over this topic for some time, writing notes on occasion and trying to put some order around this topic… What I’d like to convey is not so much the “syntax” of writing stored procedures, but some… Continue reading Stored Procedure Techniques – Online
I recently had someone ask me this question, and I didn’t know the answer. Yes, SSRS keeps track of this information in the ReportServer database, I just had to look around a little bit. Here are some quick queries to let you know what reports are in your SSRS instance and what users are running… Continue reading Who is executing my SSRS Reports?
Maybe this title is a bit misleading…another title might be “how are you monitoring your SQL Servers?” There are many ways for a DBA to keep tabs on his/her servers; I have many different T-SQL scripts to grab info when I need it. However, I frequently run into the same issue; I can run these… Continue reading Are you using SSRS?
One of my SQL Agent jobs recently started throwing the following error: Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error 22050). This job has run successfully for years…Why the sudden error? I searched the web for answers and found articles that told me that my SQL Agent service account wasn’t setup… Continue reading Sp_Send_dbmail error
On our project, I have started implementing a small design change; we will be phasing out the use of the DATETIME datatype and begin using DATETIME2 instead. Why? Please read one of the articles referenced at the end for technical specifics, but the summary is that 1) DATETIME2 is ANSI standard, and 2) Microsoft is… Continue reading Moving from Datetime to Datetime2
When developing T-SQL code for your application you often need to review the definitions of various database objects or search for dependencies in the existing objects and code to ensure that you are making the correct and complete set of changes for your requirements. SSMS is often a good tool for that and most objects… Continue reading Viewing Object Definition and Dependencies