|
|
-
|
|
A step-by-step guide on how you can install the help/Books-On-Line/Product documentation collections for SQL Server 2012 in two modes - offline and online for firewall and proxy restricted environments....
|
|
-
|
|
SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say – “simply replace EXEC with calls to sp_executesql and the system becomes SQL injection-proof”. This has to be the biggest misconception of all times around this subject....
|
|
-
|
|
Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the situation....
|
|
-
|
|
What permissions does one need to capture SQL traces using SQL Server Profiler? Is it essential that the user must be a member of the sysadmin fixed server role? This post shows the minimal permissions required for a user to capture SQL traces using the SQL Server Profiler and demonstrates the necessary command to assign a login these permissions....
|
|
-
|
|
Storage, although cheap is a limited resource. When working with multiple backups, it becomes essential to backup the databases using compression. Today's post explores how backups can be made smaller by compressing them using native SQL Server functionality - either individual (i.e. with each backup) or as a SQL Server instance level setting - 'backup compression default'....
|
|
-
|
|
When documenting a database, one of the first things that is done is to document the list of tables in the database and the primary and foreign keys to establish a relationship between them. Today, I will share 7 different scripts to identify primary and 6 different scripts to identify foreign keys within a SQL Server database....
|
|
-
|
|
Open connections consume server resources. If you need to frequently disconnect all your open connections to the corresponding SQL server instances from the multiple queries open in SQL Server Managment Studio (SSMS), this neat little feature built into the SSMS can come in handy....
|
|
-
|
|
See how to use the "Navigate To" window in the SQL server Management Studio (SSMS) for SQL Server 2012 ("Denali") in order to quickly search for files within a solution....
|
|
-
|
|
Do you know when your SQL Server instance was restarted? Can you find it using a simple T-SQL query? Today I share some of my learnings around the sys.dm_server_services DMV; while also documenting the known method of using sys.sp_readerrorlog to read the SQL server error logs....
|
|
-
|
|
How do you script your database objects using T-SQL? I explore 3 different methods that I know about in this post....
|
|