SQL Server Guest User – Still a Serious Security Threat
One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...
2012-08-31 (first published: 2012-08-28)
5,280 reads
Minnesota SQL Saturday (#SQLSat149)
It’s close to that time of year again. It’s time for a SQL Saturday in Minnesota and this… it isn’t...
2012-08-28
943 reads
Please, Call Me Richard
I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good....
2012-08-28
1,284 reads
The INSTALLSHAREDWOWDIR command line value is not valid.
I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly...
2012-08-28
1,585 reads
Say Seminar, Not Pre-Con for SQLSaturday
I read a note posted on the OPASS LinkedIn site today about our upcoming SQLSaturday and the two pre-cons by...
2012-08-28
1,032 reads
Enable Transparent Data Encryption
This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do,...
2012-08-30 (first published: 2012-08-28)
4,068 reads
PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it
I recently had the need to script the execution of a command-line utility and thought it would be a good...
2012-08-29 (first published: 2012-08-28)
28,577 reads
A Novel Workaround for an Infamous SSAS Connection Error
For months I’ve been itching to get the latest version of SQL Server, thanks to the addition of new functionality...
2012-08-28
1,925 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. With proper planning and attention to...
2012-08-27
88 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data...
2012-08-27
3,898 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers