A SQL Server Hardware Nugget A Day – Day 1
Well, I apparently did not learn my lesson last year, when I did a month long series called “A DMV...
2011-04-02
431 reads
Blog Posts
A SQL Server Hardware Nugget A Day – Day 2
For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...
2011-04-02
546 reads
If you fire that trigger, make sure you have the correct ID
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
577 reads
Powershell day 2
Day 2 Introduction to Windows Powershell. Windows Powershell is a very powerful shell script to interact with windows. Using windows...
2011-04-02
1,472 reads
SQL Saturday #63 – Dallas: Resources
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
644 reads
SQLSaturday #63, Great Event!
So,
I actually had a early morning sessions and gave my Solid State Storage talk and had a great time. The audience was...
2011-04-02
639 reads
SSMS Tips & Tricks – Scripting Multiple Objects
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,371 reads
T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
905 reads
A 22 Hour Layover
I joked about having a 22 hour layover in Denver yesterday and a few people were wondering what airline screwed...
2011-04-01
855 reads
Announcing The Association For SQL Server
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
402 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers