Scripting SQL Server databases with SMO using EnforceScriptingOptions
Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.
2014-12-08
2,662 reads
Johan Bijnens
Instant File Initialization and restores
Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.
2012-05-21
4,207 reads
Me, myself and Powershell
Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.
2011-12-06
7,566 reads
2011-09-05 (first published: 2007-01-25)
3,072 reads
Reset count for all alerts
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
357 reads
2009-08-03
3,090 reads
Scope: The drastic caveat with Logon Triggers.
In this article, Johan Bijnens shows how logon triggers can bite you in the back.
2008-12-15
7,585 reads
2008-09-10
4,454 reads
HowTo prevent BOL getting Online help
Books Online will try to connect to the net and it may get stuck if there is no internet connection.
2008-06-16 (first published: 2008-05-07)
409 reads
2007-12-21 (first published: 2007-10-25)
1,376 reads
Blogs
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - PASS Video
By Rayis Imayev
(2019-Oct-23) Video recording of my webinar session on Continuous Integration and Delivery (CI/CD) in Azure...
Invest in Yourself Stop Making Excuses
Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me...
Every Execution Plan Is An Estimated Plan
I consider myself to be the most responsible for making such a huge deal...
Forums
SQL Management studio 2014 express edition
Guys, Can I use SSMS 2014 Express edition to connect to a lower and...
unable access sql provider in powershell without running an invoke-sqlcmd first
I encountered a weird issue and hope that somebody may have a fix for...
Function to pad Bigint with leading zeros or other single characters
Comments posted to this topic are about the item Function to pad Bigint with...
Ask SSC