My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server. When not working I like to lift weights, play music, and travel with my wife.
Today's post was prompted by SQL On Ice. He proposed that we take this week's TSQL Tuesday to show our appreciation of people who have helped us. I've said it before, in my recap for SQL Cruise, that one of the best things about working with SQL Server is the community. There's no way I'd be where I am today without it. When I first started attending user groups and SQL Saturdays, I felt like the "stupid" person in the class. But, as it turned out, there is no such thing as
This post is meant to be a quick primer on Table Partitioning in SQL Server. What is it? Let's say you have a large table that is accepting a lot of transactions, partitioning allows you to scale this particular table out into different (physical partitions). Thus spreading out the I/O across multiple files and even disks. Why do I need it? While the integrity of the data or table remains intact, almost transparent to front end queries (still seen as a single table), but the
Is this where clusters go when they die? A great way to test failover or to simply move disable a clustered SQL Service is to utilize powershell. You can create a script and hand it over to the server team or you can schedule it. Most of the time certain cluster maintenance tasks take place after business hours. And if you've already worked a long day, it may free up a bit of your time and energy to use powershell. Now, the failover cluster module is only available if Failove