Star Schema The Complete Reference – Review
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph...
2014-01-23
1,184 reads
More on Password Managers
Last week I posted about reviewing passwords and mentioned using a password manager as part of that effort. DaniSQL noted...
2014-01-23
795 reads
Its the little things – Service Master Keys
In advance of the yearly licensing reconciliation with Microsoft at work, I have led the charge to ensure all of...
2014-01-23
626 reads
Rochester – Welcome to the PASS MN Family
It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At...
2014-01-23
680 reads
Powershell in a Month Day 12 – A Practical Interlude
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-22
872 reads
Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
2,273 reads
Tip: Jobs without a scheduled run
It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...
2014-01-22
537 reads
Using multiple CTEs in one query
This is a fairly simple thing to do, but I had to look it up the other day and thought...
2014-01-22
1,403 reads
Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
511 reads
Volunteers Needed For PASS SUMMIT
Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee.
Not know what PASS is? head...
2014-01-22
1,172 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