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,242 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,081 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,326 reads
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,626 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
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Hi, below i show various results trying to reach our ftp site (a globalscape...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers