Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,567 reads
SQL Guatemala
Check instant file initialization and lock pages in memory options
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,470 reads
What it is Page Life Expectancy (PLE)
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
189 reads
Collation considerations to create robust queries
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
184 reads
Add a custom report to SSMS
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
522 reads
Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
79 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
94 reads
Quick tip: Refresh IntelliSense cache in SSMS
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
248 reads
Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
4,964 reads
Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
76 reads
Blogs
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Comparing Two Scripts with kdiff3
By Steve Jones
I had a customer recently ask if SQL Compare could show them the differences...
Forums
activity monitor is showing two diffrent spid for one big stored procedure.
hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....
Commit transaction inside loops
Hello, our users are complaining about blocking during a delete loop so I'm thinking...
The subscription contains parameter values that are not valid
Hi, I've got an issue on SSRS where I have a daily subscription that...
Ask SSC