SQL Server Installation Checklist
Many people have published SQL Server installation checklists before. Here is one I have been using for several installations without...
2014-04-01
15,023 reads
JR
Replication Agent Failure
I recently spent several days investigating a replication failure. Finding the answer specific to my problem was difficult, so I...
2011-08-08
6,455 reads
Poor man’s SQL monitor
Here is quick tip that can help you track SQL Job and Alert notifications in Microsoft Outlook. Many of you...
2011-06-20
887 reads
Managing Data Change
Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...
2011-05-20
1,861 reads
The First Post
I have been a SQL Server DBA and Developer for nearly ten years. In that time I have amassed a...
2011-05-05
431 reads
Blogs
Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2
By MUTHUKKUMARAN KALIYAMOORTHY
How to read execution plan to improve poorly... [[ This is a content summary only....
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Use T-SQL, not the GUI
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Forums
business intelligence development studio(Bids)
Hello, I have a SQL 2017 and I want to use business intelligence development...
MEMORY CONSUMPTION SQL 2012
hi all, as you can see in attachment sql take 122 giga memory. and...
Issue with max() and aggregate, missunderstanding
Hi all, this is my first post here and I've been looking and trying...
Ask SSC