A quick video showing that the mdf and ldf files are actually ** NOT ** dropped during server restart. Thanks to Mike for bringing up this topic. https://www.youtube.com/watch?v=N4eB-uY5MYI […]
A ton of MS E-books to download
I am not sure how many other users have visited this blog but it’s been one of my go to places when I wanted to read up on […]
Renaming all columns in a table quickly
Recently imported a table where the column names where quoted using double quotes which then became the table names , So a column name would be “Airline” instead […]
The hazards of data types when deleting data
Recently in one of the forums a question was posted where the developer had run a delete statement similar to the one below This deleted all the data […]
Does Partitioning Improve Performance?
Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This […]
Very Large datasets GB to TB – Where to get them for free?
Every once in a while I need a very large dataset to work with, most often this required creating dummy data using one of my favorite data generators […]
Measuring Uptime in SQL Server – Why nines don’t work
A key part of every DBAs jobs is maintaining uptime. A DBAs capability is measured by the amount of Uptime he is able to ensure on servers he […]
SSIS and SSRS Training for Wells Fargo
4 day training for MS SQL Server SSRS and SSIS with Wells Fargo in Whitefield Bangalore. It’s going to be awesome. Going to create and SQL Server Monitoring […]
LnT Infotech SQL Server Training
Just finished a virtual training for LnT InfoTech in EPIP industrial Area. Looking forward to the next training with Well Fargo
Full Text Search on Varbinary (max) Columns and using the Right filters
I love Full text search in MS SQL Server. Although I haven’t seen it being used a lot in client locations, I do use it a lot within […]