|
|
All Articles
- 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
- 30/06/12: Changing MAC address in a Windows server
- 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 2008 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 list all database files in SQL Server
- 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
|
|
Follow Us!