SQL Bits 8 will be in Brighton in the UK on April 7th-9th. There are paid full days of training as well as a free day on Saturday. Register now for the premier SQL Server event in the UK.
2011-03-23 (first published: 2011-01-25)
4,818 reads
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-23
1,554 reads
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
12,339 reads
Join MVP Andy Leonard and Steve Jones in this webinar where you will learn how to get better control over your code and maintain versions using source control.
2011-03-22 (first published: 2011-03-10)
3,098 reads
G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...
2011-03-22
3,044 reads
Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.
2011-03-22
7,301 reads
Learn dimensional modeling, cube design, MDX calculations and more in this 4 day online class from Pragmatic Works featuring BI expert Stacia Misner.
2011-03-21
1,329 reads
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,633 reads
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-21
1,115 reads
SQL Server Service Broker allows for two types of messaging activation, Internal Activation or External Activation. In this article we discuss External Activation.
2011-03-21
2,453 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers