|
|
-
|
|
This series attempts to explore one of the most frequently used, but perhaps least understood feature of Microsoft SQL Server - IDENTITY columns....
|
|
-
|
|
Starting today, I present a series that explores one of the most frequently used, but perhaps least understood feature of Microsoft SQL Server - IDENTITY columns. Today's post presents an introduction to the IDENTITY column and lists the general rules around it....
|
|
-
|
|
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....
|
|