Column alias in order by and where
If you ever wonder why column alias can be used in order by and not in where clause, it’s the...
2011-11-08
6,899 reads
Blog Posts
CONVERT Dates and Confusion
Right I've been itching to post another Blog and actually contribute something this time. This isn't something I've learned but something I've taught many...
2011-11-08
795 reads
How much space are you wasting?
A few weeks back a client of mine asked me to write a script that could tell him the space...
2011-11-08
855 reads
Inline TVFs can't use FORCE ORDER hint but Multi-Statement TVFs can...?
Doing some work with converting Multi-Statement TVFs to Inline TVFs and I'm finding that the Inline TVFs cannot use the...
2011-11-08
686 reads
My Playbook For Putting On a SQLSaturday Part 1
The Long Road
I am going to post this as a series covering, in detail, everything humanly possible about the logistics...
2011-11-08
1,283 reads
PASS Board Of Directors Interview
I had my telephone interview for the PASS Board of Directors this afternoon and I'm cautiously optimistic that I did...
2011-11-08
632 reads
Quite a salary
If this article is true, and I suspect it is for some software engineers, why aren’t more people learning programming?
I...
2011-11-08
1,063 reads
SQL Saturday #99 Minnesota on Friday 11/11/11
SQL Saturday 99 on Friday is upon us. I look forward to seeing you at the event. For details check...
2011-11-08
398 reads
SQL Server security webinar now available on-demand
Last week I was able to give a SQL Server security webinar with Quest Software and SQL Server MVP Kevin...
2011-11-08
1,166 reads
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
This blog entry is participating in T-SQL Tuesday #024, hosted...
2011-11-08
1,786 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers