Identify SQL Accounts Without Password Policy Enforced
When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray!...
2017-03-02
462 reads
Blog Posts
Implicit Time Conversions – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-02
757 reads
Loading to Azure from On-Prem SSIS
In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...
2017-03-02
427 reads
Power BI Hands-On Workshops in April, 2017
During the month of April, I will be delivering three full-day Power BI hands-On workshops. Each of these events will...
2017-03-02
363 reads
Random Blog Post Challenge
OK, for no particular reason at all or maybe because I had too much food at lunch or just because...
2017-03-02
396 reads
ScriptDom parsing and NoViableAltExceptions
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will know that the process is extremely slow and...
2017-03-02
19 reads
ScriptDom parsing and NoViableAltExceptions
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you...
2017-03-02
732 reads
ScriptDom parsing and NoViableAltExceptions
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you...
2017-03-02
47 reads
ScriptDom parsing and NoViableAltExceptions
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you...
2017-03-02
39 reads
SQL Server Permissions – Database Roles
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:
When Too Much is Not a Good Thing December...
2017-03-02
81 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers