|
|
-
|
|
How do you ensure that a given database belongs to your product? This post presents two of my most used approaches....
|
|
-
|
|
Some of the common SQL Server interview questions around DML triggers are: How does one identify active v/s disabled triggers and their corresponding trigger events? How can one determine if a trigger is an instead of trigger or not? Today's post presents a simple script using sys.triggers and sys.trigger_events to answer this question....
|
|
-
|
|
Generating multi-part names (four-part, three-part or two-part) for database objects and interpreting them can be labour intensive at times. This post provides scripts that can be used to reduce the manual effort required for these activities...
|
|
-
|
|
Most database documentation and code fail to address name resolution errors – i.e. the ability to ensure that a name uniquely identifies a database object. This post provides an introduction to four-part, three-part and two-part database object naming conventions....
|
|
-
|
|
Have you ever tried to write T-SQL code that conforms completely to the ISO standard? Since Microsoft SQL Server's T-SQL standard is based on the ISO standard, doing so is quite possible. Today, I explore the ISO equivalents of the EXISTS keyword - SOME or ANY....
|
|
-
|
|
Extending the Windows user experience of file searches to SQL server is a bit of a challenge because the asterisk [*] is a wild-card character in Windows whereas SQL Server uses percentage [%]. The percentage [%] is valid in a file name which adds to the complications. Today's post presents an approach to realize such a requirement using the ESCAPE keyword....
|
|
-
|
|
Changing the SQL Server collation once a SQL Server instance has been installed is a tedious process because it involves recreating the master database. Many believe that the server collation is picked up by default and must be changed by master database recreation only. In this post, I show how to ensure that the installation itself always uses the required collation....
|
|
-
|
|
Forgetting the "sa" login is an issue frequently seen in development & QA environments. Generally the Windows login works, but in some cases the IT team who installed the server may have forgotten to add someone to the sysadmin role. This post provides a proactive recommendation and link to a workaround....
|
|
-
|
|
Microsoft installers have generally been a source of inspiration for all product development teams. Here is one installation check that I believe should be common to all product installers - the long path name check....
|
|
-
|
|
If you ever need to get a list of installed SQL Server features and their respective patch levels, the Installed SQL Server Feature Discovery Report bundled with the SQL Server installer can be used. This post gives a step-by-step guide about using this handy utility....
|
|