Explore >> Select a destination
|
You are here 
|
sqlstudies.com | ||
| | | | |
callihandata.com
|
|
| | | | | How are you deploying updates to your databases? Do you run a SQL script that you receive from developers? Maybe you have a SQL job that takes a script stored at a specified location and applies it to all user databases. Another option for deploying updates that you may not be as familiar with is... | |
| | | | |
erikdarling.com
|
|
| | | | | [AI summary] The article discusses wrapper stored procedures in SQL Server, their advantages and disadvantages, and when to use them versus dynamic SQL. | |
| | | | |
dbafromthecold.com
|
|
| | | | | When I first started working with SQL on Linux one of the first things I did was to remove the default the [BUILTIN\Administrators] login. This is pretty much standard practice with SQL on Windows as we don't want administrators on the server to have automatic sysadmin rights into the SQL instance. But this login makes... | |
| | | | |
gorandalf.wordpress.com
|
|
| | | Each SQL Server database has a setting called Compatibility Level that determines how T-SQL commands are interpreted and what features are supported for that database. A singleSQL instance can host multiple databases withdifferent compatibility levels, so SQL statementsthat work onone database might not work onthe other. Each version of SQL Server introduces a new compatibility... | ||
