Scripting SQL Server databases with SMO using EnforceScriptingOptions
Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.
2014-12-08
2,778 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,221 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,578 reads
2011-09-05 (first published: 2007-01-25)
3,166 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)
368 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,649 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,377 reads
Blogs
How I passed the 70-761 certification exam
By DesertDBA
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Forums
Pivot in multiple inner joins
this is my query, which gives me the complains details SELECT * FROM CI_TD_ENTRY...
how about explaining your RegEx logic?
RegEx is always tough to digest (without referring to document), so it would be...
Relatively easy query assistance - datediff
Hi all, I have a question since I'm new to SQL: I have a...
Ask SSC