- 26/04/16: How to List all Mirrored SQL Server Databases
- 12/04/16: How to specify a Port Number to Connect to SQL Server Instance
- 27/03/16: How install SQL Server 32Bit on Windows 64Bit
- 11/03/16: Find all Tables with and without Identity column in SQL Server Database
- 22/02/16: Find all Filtered Indexes in SQL Server Database
- 15/02/16: Find all Indexes that have Included Columns in SQL Server Database
- 18/01/16: Find all Primary Key Columns from a SQL Server table
- 10/01/16: How to get Column names of a Table or a View in SQL Server
- 08/01/16: Find all Tables with Specified Column Name in a SQL Server Database
- 22/12/15: Find Tables without Clustered Index and with Primary Key in a SQL Server Database
- 15/12/15: List Tables with Foreign Key Constraint in a SQL Server Database
- 25/11/15: List all User Tables With and Without Primary Key Constraint in a SQL Server Database
- 09/11/15: List all User Tables in a SQL Server Database with no Clustered Index
- 27/10/15: Find Fill Factors for Indexes in a SQL Server Database
- 05/10/15: SQL Server Remote Query Timeout Setting
- 19/09/15: Add Folder Permissions to Virtual Account “NT SERVICE\MSSQLSERVER”
- 12/08/15: How to add Unique Constraint on multiple columns in SQL Server
- 06/07/15: OUTPUT Clause in SQL Server
- 15/06/15: SQL Server Configuration Manager not found in Programs list
- 24/05/15: Set First Day of the Week in SQL Server
- 19/05/15: Built-in Logical Function CHOOSE in SQL Server
- 11/05/15: How to Script SQL Server Configuration Options
- 03/05/15: How to List all Disabled Indexes in a SQL Server Database
- 27/04/15: How to Disable and Enable Index in SQL Server
- 21/04/15: SQL Server Buffer Pool Memory used by each Object and each Database
- 16/04/15: SQL Server Views WITH CHECK OPTION
- 10/04/15: See the Default Schema of SQL Server Database Users and Groups
- 02/04/15: How to List all SQL Logins with Passwords not Enforced by Policies
- 30/03/15: How to List all Locked SQL Logins in SQL Server
- 22/03/15: EOMONTH Function to Get First and Last Day of a Month in SQL Server
- 12/03/15: Concatenate SQL Server Columns that contain NULL values
- 02/03/15: How to specify Values for SSMS Template Parameters
- 26/02/15: How to open SQL Server Management Studio Template Explorer
- 17/02/15: Display Results in a Separate Tab in SSMS Query Editor
- 11/02/15: How to Maximize the Query Editor Window in SSMS
- 05/02/15: Horizontal and Vertical Tab Groups in SSMS
- 29/01/15: SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ – Error 15281
- 24/01/15: Script Multiple SQL Server Database Objects in SSMS
- 15/01/15: Block Text Selection in SSMS Query Editor Window
- 10/01/15: Split a Query Editor Window in SQL Server Management Studio (SSMS)
- 06/01/15: Web Browser in SQL Server Management Studio (SSMS)
- 03/01/15: How to move an Object to a different Schema in SQL Server
- 23/12/14: Right Align Numeric Values in SQL Server Management Studio
- 18/12/14: How to Set, Disable and Delete Breakpoints in SQL Server Management Studio
- 11/12/14: Keyboard Shortcut to show Query Execution Plans in SQL Server Management Studio
- 06/12/14: Keyboard Shortcut to Delete Entire Line in SSMS Query Editor Window
- 26/11/14: Drag Column Names from SSMS Object Explorer to Query Editor Window
- 19/11/14: How to drop multiple SQL Server Objects using single DROP statement
- 07/11/14: Filtering objects in SQL Server Management Studio (SSMS) Object Explorer
- 04/11/14: List all Tables that have Change Data Capture (CDC) enabled on a SQL Server Database
- 30/10/14: List all Tables that have Change Tracking (CT) enabled on a SQL Server Database
- 25/10/14: How to check if Change Data Capture (CDC) is enabled on a SQL Server Database
- 10/10/14: How to check if Change Tracking (CT) is enabled on a SQL Server Database
- 02/10/14: How to Implement SSIS Package Checkpoints
- 27/09/14: How to List all Contained Users in a SQL Server Contained Database
- 14/09/14: Built-in Logical Function IIF in SQL Server
- 05/09/14: How to Create a Contained User in a SQL Server Contained Database
- 28/08/14: SQL Server – The sp_configure value ‘contained database authentication’ must be set to 1 in order to create a contained database. – Error 12824
- 17/08/14: How to List all Contained Databases in a SQL Server Instance
- 05/08/14: How to get Current Value from a SQL Server SEQUENCE
- 01/08/14: SQL Server – The sequence object has reached its minimum or maximum value – Error 11728
- 30/07/14: N Prefix for Unicode strings in SQL Server
- 22/07/14: Start SQL Server Agent when ‘Agent XPs disabled’
- 14/07/14: User Defined Function (UDF) to Convert Speed between Km/h and mph in SQL Server
- 02/07/14: User Defined Function (UDF) to Convert Speed between Km/h and m/s in SQL Server
- 20/06/14: User Defined Function (UDF) to Convert Volume between Cubic Meters and Cubic Feet in SQL Server
- 15/06/14: User Defined Function (UDF) to Convert Area between Square Kilometers and Square Miles in SQL Server
- 10/06/14: User Defined Function (UDF) to Convert Area between Square Meters and Square Yards in SQL Server
- 24/05/14: User Defined Function (UDF) to Convert Area between Square Meters and Square Feet in SQL Server
- 11/05/14: User Defined Function (UDF) to Convert Area between Hectares and Acres in SQL Server
- 02/05/14: User Defined Function (UDF) to Convert Length between Meters and Yards in SQL Server
- 28/04/14: User Defined Function (UDF) to Convert Length between Feet and Inches in SQL Server
- 15/04/14: User Defined Function (UDF) to Convert Length between Centimeters and Inches in SQL Server
- 03/04/14: User Defined Function (UDF) to Convert Length between Meters and Feet in SQL Server
- 23/03/14: User Defined Function (UDF) to Convert Length between Kilometers and Miles in SQL Server
- 14/03/14: User Defined Function (UDF) to Convert Weight between Grams and Ounces in SQL Server
- 07/03/14: User Defined Function (UDF) to Convert Weight between Kilograms and Pounds in SQL Server
- 25/02/14: User Defined Function (UDF) to Convert Temperatures between Fahrenheit and Celsius in SQL Server
- 14/02/14: Failed Maintenance Plan with DTSER_FAILURE error in SQL Server
- 08/02/14: How to Insert XML Data directly into a SQL Server Table
- 30/01/14: How to Import XML data from XML File using OPENROWSET in SQL Server
- 19/01/14: How to UPDATE a Table with Values from Other Table in SQL Server
- 09/01/14: How to Insert Binary Data into a SQL Server Database
- 04/01/14: SQL Server Service Broker cannot be enabled – error
- 27/12/13: How to Assign F5 Keyboard Key to Refresh Items in SSMS Object Explorer
- 18/12/13: User Defined Function (UDF) to Remove the File Name from a Path in SQL Server
- 09/12/13: User Defined Function (UDF) to Get the File Name from a Path in SQL Server
- 04/12/13: User Defined Function (UDF) to get the First Name from a Full Name in SQL Server
- 17/11/13: User Defined Function (UDF) to get the Last Name from a Full Name in SQL Server
- 13/11/13: Difference between UNION and UNION ALL in SQL Server
- 11/11/13: How to Get First and Last Day of a Week in SQL Server
- 07/11/13: User Defined Function (UDF) to Determine a Leap Year in SQL Server
- 06/11/13: How to Get Number of Days in a Month in SQL Server
- 04/11/13: User Defined Function (UDF) to Determine if a String is a Palindrome
- 03/11/13: How to Change the Password of a Login in SQL Server
- 01/11/13: How to Enable, Disable or Rename a Login in SQL Server
- 27/10/13: How to Change the Default Language for a Login in SQL Server
- 26/10/13: How to Change the Default Database for a Login in SQL Server
- 24/10/13: Example of WHILE Loop in SQL Server
- 22/10/13: How to Get First and Last Day of a Quarter in SQL Server
- 18/10/13: How to Get First and Last Day of a Year in SQL Server
- 15/10/13: How to Get First and Last Day of a Month in SQL Server
- 13/10/13: UNPIVOT Examples in SQL Server
- 11/10/13: PIVOT Examples in SQL Server
- 08/10/13: How to Delete FILESTREAM Data in SQL Server
- 06/10/13: How to Update FILESTREAM Data in SQL Server
- 05/10/13: How to Insert Data into a FILESTREAM Table in SQL Server
- 21/09/13: How to Get the Quarter from a Date in SQL Server
- 21/09/13: How to Get the Day of the Year from a Date in SQL Server
- 21/09/13: How to Get the Week Number from a Date in SQL Server
- 21/09/13: How to Get the Month Name from a Date in SQL Server
- 21/09/13: How to Get the Day of the Week from a Date in SQL Server
- 21/09/13: Differences Between LEN and DATALENGTH Functions in SQL Server
- 12/09/13: How to Add a FILESTREAM Column to an Existing SQL Server Table
- 12/09/13: How to Create a SQL Server Table with a FILESTREAM Column
- 12/09/13: How to Enable FILESTREAM on the SQL Server Instance
- 11/09/13: How to Enable FILESTREAM on an Existing SQL Server Database
- 11/09/13: How to Create a FILESTREAM Enabled SQL Server Database
- 31/08/13: ‘Not Equal To’ comparison operators in SQL Server
- 05/08/13: How to List all Databases in a SQL Server Instance
- 05/08/13: How to List all Views in a SQL Server Database
- 05/08/13: How to List all Tables in a SQL Server Database
- 05/08/13: How to List all Columns in a SQL Server Table
- 05/08/13: Difference Between GETDATE and CURRENT_TIMESTAMP in SQL Server
- 05/08/13: How to Change a Nullable Column to NOT NULL with Default Value in SQL Server
- 03/08/13: “Cannot resolve the collation conflict” in SQL Server
- 02/08/13: User Defined Trim Function in SQL Server
- 01/08/13: How to Change a Nullable Column to NOT NULL
- 29/07/13: SQL Server Stored Procedure for Generating Random Passwords
- 29/07/13: SQL Server User Defined Function (UDF) for Generating Random Passwords
- 25/07/13: How to List Fixed Drives and Their Free Space from SQL Server
- 24/07/13: How to use RAND() in SQL Server User Defined Functions (UDF)
- 24/07/13: How to use NEWID() in SQL Server User Defined Functions (UDF)
- 20/07/13: Cannot open user default database. Login failed. – Error 4064
- 20/07/13: Fixing orphaned users in a SQL Server database
- 19/07/13: How to Remove Secondary Data File from SQL Server Database
- 17/07/13: Add Data Files to SQL Server tempdb Database
- 12/07/13: Orphaned ‘dbo’ User in a SQL Server Database
- 01/07/13: Database diagram support objects cannot be installed because this database does not have a valid owner – Error
- 28/06/13: How to add a Computed Checksum Column to a SQL Server Table
- 27/06/13: How to Insert N Random Dates between a given range into a SQL Server Table
- 27/06/13: How to Insert N Numbers into a SQL Server Table using WHILE Loop
- 24/06/13: Select data directly into Variables in SQL Server
- 18/06/13: How to check if the SQL Server Database is Online
- 18/06/13: How to check if the SQL Server Database exists
- 17/06/13: How do you add a Column with a Default value to an existing SQL Server Table
- 17/06/13: How to Create Table in a SQL Server Database if it does not exist
- 17/06/13: How to check if the User exists and Drop User from SQL Server Database
- 01/06/13: How to replace NULL with a different value in a query result in SQL Server
- 01/06/13: List all Nullable or Non-Nullable Columns in a SQL Server Table
- 01/06/13: List Rows with NULL values in a Column in SQL Server
- 27/05/13: How to check if the View exists in a SQL Server Database
- 27/05/13: How to check if the Table exists in a SQL Server Database
- 26/05/13: How to check if the Column exists in a SQL Server Table
- 24/05/13: Effect of Rollback Transaction on Table Variable in SQL Server
- 22/05/13: Bookmark Lines of Code in SQL Server Management Studio Query Editor Window
- 21/05/13: Go To Line Number in SQL Server Management Studio Query Editor Window
- 21/05/13: Display Line Numbers in SQL Server Management Studio Query Editor Window
- 17/05/13: List all Table Columns that have Collations different than the SQL Server Database
- 17/05/13: List all Column Collations for all Tables in a SQL Server Database
- 04/05/13: List all supported SQL Server Collations and the Code Page of the Collation
- 04/05/13: List Databases that have a different Collation than the SQL Server Instance
- 28/04/13: Find Collation of a SQL Server Instance
- 28/04/13: Change Collation of a SQL Server Table Column
- 27/04/13: Find Collation of a SQL Server Database and Table Column
- 20/04/13: Case Inensitive Query on a Case Sensitive Column in SQL Server
- 20/04/13: Case Sensitive Query on a Case Insensitive Column in SQL Server
- 18/04/13: Option to open new queries in SQLCMD mode by default in SSMS
- 15/04/13: Run SQL Server Management Studio as Different User
- 15/04/13: Start or Stop SQL Server Services using SQLCMD
- 13/04/13: Restore a SQL Server Database from Striped Backup Files
- 13/04/13: Difference between Mirrored and Striped Database Backups in SQL Server
- 30/03/13: Creating SQL Server Database Snapshot – Error 5014
- 30/03/13: SQL Server Database is enabled for Database Mirroring, but the database lacks quorum, and cannot be opened – Error 955
- 22/03/13: How to Recover a SQL Server Database that is in the Restoring State
- 22/03/13: How to Remove SQL Server Database Mirroring
- 22/03/13: How to Change Transaction Safety in a SQL Server Database Mirroring Session
- 22/03/13: How to Add or Replace the Witness in a SQL Server Database Mirroring Session
- 22/03/13: How to Remove the Witness from a SQL Server Database Mirroring Session
- 12/03/13: How to REVOKE CONNECT on a Mirroring Endpoint in SQL Server
- 12/03/13: List logins that have Permissions on SQL Server Mirroring Endpoint
- 04/03/13: How to Manually Failover a SQL Server Database Mirroring Session
- 03/03/13: How to Resume a SQL Server Database Mirroring Session
- 02/03/13: How to Pause a SQL Server Database Mirroring Session
- 01/03/13: Database mirroring must be removed before you drop SQL Server database – Error 3743
- 23/02/13: Restoring the Default Window Layout in SQL Server Management Studio
- 23/02/13: Find and Replace text in SQL Server Management Studio
- 23/02/13: Indenting Code in SQL Server Management Studio
- 19/02/13: List all Jobs set to Start Automatically when SQL Server Agent starts
- 19/02/13: Schedule a Job to Start Automatically when SQL Server Agent starts
- 16/02/13: How to Enable and Disable the Default Trace in SQL Server
- 15/02/13: Commenting and Uncommenting Code in SQL Server Management Studio
- 09/02/13: List all Stored Procedures set to Automatically Run at SQL Server Startup
- 09/02/13: Configure Stored Procedures to Automatically Run at SQL Server Startup
- 07/02/13: How to use Wildcard Characters in LIKE Operations in SQL Server
- 26/01/13: Keyboard Shortcut to make selected text Upper or Lower Case in SSMS
- 26/01/13: Keyboard Shortcut for Database Selection in SQL Server Management Studio
- 14/01/13: Encrypting Stored Procedures in SQL Server
- 11/01/13: Find out Windows computer name on which the SQL Server instance is running
- 11/01/13: Fixing Error: “Sql Server replication requires the actual server name to make a connection to the server.”
- 11/01/13: Keyboard shortcut for Windows to minimize all open windows and display the desktop
- 11/01/13: Keyboard shortcut for Windows to Start Task Manager
- 11/01/13: Keyboard shortcut for Windows to View the Properties of a File or Folder
- 08/01/13: How to enable Network DTC Access and test Distributed Transactions in SQL Server
- 06/01/13: Keyboard shortcut for Windows to Lock your Computer
- 05/01/13: How to create a copy of a Table Structure in SQL Server
- 02/01/13: Deleting offline database in SQL Server doesn’t delete database files
- 23/12/12: List all disabled SQL Server logins
- 23/12/12: Enable, Disable or Rename login SA in SQL Server
- 23/12/12: How to Grant CONNECT on a Mirroring Endpoint in SQL Server
- 23/12/12: How to create a Mirroring Endpoint on Principal, Mirror and Witness SQL Server
- 22/12/12: How to start or stop an endpoint in SQL Server
- 22/12/12: List all endpoints in SQL Server
- 15/12/12: How to grant Server level permissions to login in SQL Server
- 15/12/12: How to grant Database level permissions to user in SQL Server
- 15/12/12: How to change Fonts and Colors in SSMS Query Editor
- 15/12/12: How to include column headers when copying query results in SSMS
- 14/12/12: How to Check if SQL Server Instance is Clustered
- 14/12/12: Enable IntelliSense and Refresh IntelliSense Local Cache in SSMS
- 05/12/12: How to Create and Delete an Alias in SQL Server
- 26/11/12: How to increase the number of SQL Server Error Log files
- 26/11/12: Difference between smallmoney and money data type in SQL Server
- 22/11/12: Difference between tinyint, smallint, int and bigint data type in SQL Server
- 22/11/12: How to backup, restore and regenerate the Service Master Key in SQL Server
- 19/11/12: Generating random numbers in SQL Server
- 14/11/12: Keyboard shortcut to Hide or Show SSMS Results Pane
- 06/11/12: How to list all Triggers in a SQL Server Database
- 06/11/12: List all DDL Triggers modified in last N days in a SQL Server Database
- 05/11/12: List all DML Triggers modified in last N days in a SQL Server Database
- 05/11/12: How to read SQL Server Audit Files using fn_get_audit_file function
- 31/10/12: Cycle SQL Server Error Log files using DBCC ERRORLOG
- 23/10/12: ‘Date’ and ‘Event Time’ columns in an Audit log in SQL Server are displayed in UTC
- 23/10/12: Change the value of ‘Select Top n Audit records’ in SSMS
- 19/10/12: How to use default shortcuts and assign custom shortcuts to commands in SSMS
- 17/10/12: How to insert values into IDENTITY column in SQL Server (Fixing Errors 544, 8101 and 8107)
- 11/10/12: View backup header information for SQL Server backup sets
- 11/10/12: List the data and log files contained in the SQL Server backup set
- 10/10/12: Get Database Name from Database ID and Database ID from Database Name in SQL Server
- 09/10/12: Find currently running, blocked and blocking queries in SQL Server
- 07/10/12: Renaming Windows Logins in SQL Server after Server or Domain name change
- 05/10/12: List all indexes for all tables in a SQL Server database
- 04/10/12: Find Start Time of SQL Server
- 02/10/12: How to create a deadlock between two transactions in SQL Server
- 28/09/12: Examples of infinite loops in SQL Server
- 27/09/12: Rename logical and physical names of database files in SQL Server
- 25/09/12: Connecting to SQL Server from Windows Vista – Error 18456
- 19/09/12: Standard Reports in SQL Server Management Studio
- 17/09/12: Export and import registered servers list in SQL Server Management Studio
- 14/09/12: Launch SQL Server Management Studio from Command Prompt
- 14/09/12: How to rename a database in SQL Server
- 13/09/12: Enable remote Dedicated Administrator Connection (DAC) in SQL Server
- 11/09/12: Check Date and Time of SQL Server Installation
- 11/09/12: Setting the ‘At Startup’ Options in SQL Server Management Studio
- 11/09/12: Hide System Objects in Object Explorer in SQL Server Management Studio
- 10/09/12: Change the value of ‘Select Top n Rows’ or ‘Edit Top n Rows’ in SSMS 2008
- 10/09/12: Syspolicy_purge_history job in SQL Server
- 05/09/12: Restore Master Database in SQL Server
- 29/08/12: Unable to shrink the transaction log of SQL Server database
- 29/08/12: Remove all clean buffers from the buffer pool using DBCC DROPCLEANBUFFERS
- 28/08/12: Dedicated Administrator Connection (DAC) for SQL Server Express Edition
- 27/08/12: Difference between CONTROL SERVER and sysadmin membership in SQL Server
- 16/08/12: Configure SQL Server Agent to automatically restart if it stops unexpectedly
- 15/08/12: Convert a Windows Server Partition from FAT to NTFS
- 12/08/12: Delete old entries in the backup and restore history tables in msdb database
- 10/08/12: Add and Remove Roles in Windows Server
- 10/08/12: Add and Remove Features in Windows Server
- 09/08/12: How to insert data from one table to another in SQL Server
- 09/08/12: How to create a copy of a Table using SELECT INTO in SQL Server
- 31/07/12: “Dedicated administrator connections are not supported” message in SQL Server
- 26/07/12: How to enable, disable and check if Service Broker is enabled on a database
- 26/07/12: SET ENABLE_BROKER never completes in SQL Server
- 24/07/12: How to insert Stored Procedure result into a temporary table in SQL Server
- 23/07/12: Reset table identity value in SQL Server with DBCC RESEED
- 22/07/12: Accent Sensitive and Accent Insensitive Collation in SQL Server explained
- 22/07/12: Case Sensitive and Case Insensitive Collation in SQL Server explained
- 22/07/12: Width Sensitive and Width Insensitive Collation in SQL Server explained
- 22/07/12: @@ROWCOUNT with SET NOCOUNT ON in SQL Server
- 18/07/12: How to clear DNS Cache in Windows
- 18/07/12: How to disable UAC in Windows using Msconfig
- 17/07/12: List all the Primary and Foreign keys in SQL Server database
- 17/07/12: Concatenate query results in SQL Server using Coalesce
- 16/07/12: “Saving Changes is Not Permitted” in SQL Server 2008 Management Studio
- 15/07/12: Improve SQL Server Stored Procedure performance with SET NOCOUNT ON
- 15/07/12: Avoid using sp_ as a prefix for stored procedures
- 13/07/12: How to rename an index in SQL Server
- 12/07/12: SQL Command GO in SQL Server
- 12/07/12: Enable and disable xp_cmdshell using sp_configure
- 10/07/12: SQL Server instalation log location
- 09/07/12: Disable and enable triggers in SQL Server
- 09/07/12: Disable and enable Foreign Key and Check Constraints
- 09/07/12: How to rename a table in SQL Server
- 09/07/12: How to rename a column in SQL Server
- 09/07/12: Delete records older than N days, hours or minutes in SQL Server
- 06/07/12: Insert multiple records into a SQL Server table using one INSERT statement
- 06/07/12: Unlock login without changing the password in SQL Server
- 03/07/12: Change SQL Server Agent Job Owner
- 03/07/12: Find all jobs owned by a login in SQL Server
- 03/07/12: Query to find owners of SQL Server Agent jobs
- 03/07/12: Declare variable and assign initial variable value in a single statement in SQL Server 2008
- 03/07/12: Count duplicate records or rows in SQL Server
- 02/07/12: Randomly sorting query results in SQL Server using NewId()
- 02/07/12: Select a random row from a table in SQL Server using NewId()
- 02/07/12: Xcopy to or from password protected network folder
- 29/06/12: Code to get the last day of the month in SQL Server
- 28/06/12: Rollback nested transactions in SQL Server
- 28/06/12: Delete Duplicate Rows in SQL Server 2005 and 2008 using CTE
- 27/06/12: Reporting Services – Internet Explorer security settings set to high
- 27/06/12: Disable Internet Explorer Enhanced Security in Windows Server 2008
- 26/06/12: One minute precision of SMALLDATETIME
- 05/06/12: How to force check for Windows updates
- 04/06/12: Last reboot time of Windows
- 04/06/12: Get schema and object name from object_id
- 04/06/12: Get the Name or ID of the current Database in SQL Server
- 04/06/12: Getting Table and Index names for fragmented indexes in SQL Server
- 01/06/12: Update Statistics and finding Statistics update date
- 31/05/12: Start, Stop and Restart SQL Server and SQL Server Agent from Command Prompt
- 30/05/12: Database Snapshots in SQL Server
- 29/05/12: Find the date and time of the last backup for all databases
- 29/05/12: List all Views modified in last N days in a SQL Server Database
- 29/05/12: List all Stored Procedures modified in last N days in a SQL Server Database
- 29/05/12: Move TempDB database from one drive to another drive
- 28/05/12: How to read SQL Server Trace Files using fn_trace_gettable function
- 28/05/12: Finding SQL Server deadlocks
- 27/05/12: Query to find the users and their persmissions in SQL Server Database
- 27/05/12: Simple Example of Cursor in SQL Server
- 25/05/12: How to select only date or time part from DateTime in SQL Server
- 25/05/12: How to convert VARCHAR to Integer in SQL Server with CAST and CONVERT
- 25/05/12: How to drop database user that owns a schema – SQL Server Error: 15138
- 17/05/12: How to enable and disable trace flags, or check for active trace flags in SQL Server
- 15/05/12: Saving Passwords in SSIS Packages
- 14/05/12: How to script out the database with all objects in the selected database
- 08/05/12: Start SQL Server Instance in Single User Mode
- 08/05/12: Access to SQL Server when all administrator accounts are deleted
- 05/05/12: The Server-side Trace
- 05/05/12: Login failed error messages in SQL Server – Errors 18456, 18488 and 18470
- 05/05/12: Useful Dynamic Management Views in SQL Server 2008
- 05/05/12: How to truncate and shrink the transaction log in SQL Server
- 05/05/12: Backup a Single Table in SQL Server using SSMS
- 05/05/12: Grant permissions to users to create jobs in Sql Server
- 05/05/12: How to list all the databases in SQL Server
- 05/05/12: How to Find Location of Data and Log Files of all SQL Server Databases
- 05/05/12: How to change the Compatibility Level of a Database
- 05/05/12: Missing 32 bit SQL Server PERFMON counters using 64 bit Windows
- 05/05/12: Property Owner is not available for Database ‘[DBName]’ – error