2012 in review !
Year 2012 was super special for me in many ways. Made lot of new friends, Attended SQLPASS Summit 2012 and had...
2012-12-31
1,341 reads
Replication in SQL Server
Replication is a way of distribution of database and their objects from one master database to one or more recipient databases...
2012-12-31
2,130 reads
Log Shipping in SQL Server
Log Shipping:- Log Shipping is a process of keeping the latest copy of the database of the primary database server...
2012-12-31
1,530 reads
Rebuild And Reorganization of Indexes
Rebuild and Reorganization of Indexes:- SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert,...
2012-12-31
2,747 reads
Fragmentation in SQL Server
Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. In can be defined into...
2012-12-31
1,450 reads
Wrapping Up 2012
Looking back at 2012 I feel like I’ve written less than I planned to, and in some ways done less...
2012-12-31
1,465 reads
Phones, Tablets, and Even Windows 8
Last year I purchased two Kindle Fires for the family to use. The UI could be just a little bit/slow...
2012-12-31
1,536 reads
Last Weeks Top 10 “Reading” Links #13
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-31
1,733 reads
Welcome 2013
HappyNewYear2013
May this new year bring lots of Happiness in all of your life. Let welcome 2013 together with lots of...
2012-12-31
1,295 reads
Happy New Year
I’m not working too hard today, so this is just a short post to wish all my readers a very...
2012-12-31
1,566 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers