Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with...
2012-04-18
232 reads
Blog Posts
Backup Database Object
I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...
2012-04-17
1,820 reads
Better Living Thru Powershell: Update Statistics in Parallel
As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some...
2012-04-17 (first published: 2012-04-12)
2,839 reads
Book Review: American Icon: Alan Mulally and the Fight to Save Ford Motor Company
American Icon: Alan Mulally and the Fight to Save Ford Motor Company ($18 at Amazon) was a good read, with...
2012-04-17
776 reads
Choosing the Right Microsoft Reporting Technology Part 5: Power View
In part five of this on going series about choosing the right reporting tool we will discuss the newest of...
2012-04-17
1,626 reads
ColoradoSQL–April 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-04-17
838 reads
Execute T-SQL Statement Task
I spotted a new task in SSIS 2012 – Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against...
2012-04-17
1,191 reads
Let’s Meetup [Updated]!
I have a confession to make. I like to meet people who also work with SQL Server. There are so...
2012-04-17
695 reads
Listing SQL Instances on a machine (or list of machines)
TweetG’day,
Recently I was updating some of my Powershell scripts for managing SQL SERVER instances.
Generally, when writing a Powershell script to...
2012-04-17
5,753 reads
Merge Command In Sql Server
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and...
2012-04-17
1,750 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers