SQL BLOG: Playing with Date Time
Below code returns remaining days in the month based on the input date. We can have this inside a function...
2013-02-24
426 reads
Blog Posts
A Month of PowerShell – Day 23 (JobServer: Alerts)
Welcome to Day 23 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-23
2,123 reads
Partitioning Relational Data – (Part – 3)
This is the third part of the three part article series on partitioning relational data.
In the first part of this...
2013-02-23
571 reads
SQL Server Encryption
Today, I am very happy because my first article (SQL Server Encryption) was published in SQL Server Pro. In this...
2013-02-23
1,087 reads
The pros and cons of virtualizing SQL Server environments
Virtualization is a hot trend in the computing world, offering businesses substantial cost and performance benefits that include server consolidation,...
2013-02-23
1,602 reads
XML Support and SQL Server (Part 4)
Checkout the fourth part of my XML support and SQL Server article series here.
In this part, I talked about XML...
2013-02-23
844 reads
Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies
Welcome to day 28 of my series 31 Days of Disaster Recovery. Today I want to talk about recovering SQL...
2013-02-22 (first published: 2013-02-14)
2,891 reads
Home Power – Generators
A slightly off topic post, but since I was asked recently, I thought I’d take my reply, make a post...
2013-02-22 (first published: 2013-02-14)
2,677 reads
Microsoft Azure is faster than Amazon
I just read a great article on NetworkWorld that demonstrates that Microsoft’s Azure outperforms most tests against Amazon’s AWS. That’s great...
2013-02-22
730 reads
Reblog: February 15 to February 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
916 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers