T-SQL Tuesday #051: Place Your Bets
Place Your Bets
All bets on the table please. This is the last call for bets, no new bets will be...
2014-02-07 (first published: 2014-02-04)
2,305 reads
Using sys.objects When Scripting Permissions? You're Missing Something!
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user...
2014-02-04
1,115 reads
Error Authenticating Proxy | SQL and UPNs
Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let...
2014-02-10 (first published: 2014-02-04)
1,876 reads
SQL Deep Dives at Intersection in April
SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of...
2014-02-07 (first published: 2014-02-04)
1,581 reads
Forcing a contractor to go W2
I have had a few questions like this: “I was wondering if there is a reason the vendor/broker/head hunter forces...
2014-02-04
783 reads
Upcoming Presentations
Since I took the leap last year and submitted to talk at SQL Saturday, I’ve come to enjoy the challenge that...
2014-02-04
621 reads
20 Twitter Accounts to Follow For the 2014 Winter Olympics
Wondering how to stay informed and entertained during the 2014 Winter Olympics? Here are 20 Twitter accounts to get you...
2014-02-04
580 reads
Conditional Aggregates
The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...
2014-02-11 (first published: 2014-02-04)
3,099 reads
How Big Data Changed Finance at Microsoft
Finance leaders today are faced with an interesting challenge. How can they consume and analyze the millions of rows of...
2014-02-04
390 reads
SQL Saturday #273 Tampa
The year of SQL Saturdays!
Tampa is the second SQL Saturday that I’ll be speaking at this year. For the...
2014-02-04
242 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
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...
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