Posts
- How to Kill All MySQL Processes For a Specific User
- MySQL Replication Use Cases
- What is MySQL Replication and How Does It Work?
- T-SQL - How to Select Top N Rows for Each Group Using ROW_NUMBER()
- Data Management - Finding, Removing Duplicate Rows Using SQL and Some Prevention Tips
- T-SQL - Determine the Difference in Values Between Columns in Different Rows
- SQL - Using CASE with ORDER BY in Stored Procedures
- How to Produce CSV Format Using T-SQL
- T-SQL - Derived Tables Demonstrated and Explained
- 10 Database Performance Monitoring Tools You Can Get For Free
- When are Innodb Table Statistics Updated?
- MySQL Replication Events - Statement versus Row-Based Formats
- MySQL SHOW USERS? - How to List All MySQL Users and Privileges
- List Tables for a Specific Database Using MySQL SHOW TABLES
- How to List MySQL Databases Using SHOW DATABASES
- Using SELECT TOP WITH TIES in SQL Server
- How to Resize MySQL Innodb Log Files Without Errors
- Comparing Ways to Get Table Row Counts in MySQL and SQL Server
- How to Install MySQL 5.5 on Ubuntu Server 12.04 LTS
- How to Rename a SQL Server Column or Table Using T-SQL
- Implementing a Simple SQL Server Backup Script
- Using DBCC SQLPERF
- SQL Server 2016 New Features - Dynamic Data Masking
- How to fix "conversion failed when converting date and/or time from character string"
- Using SQL GROUPING SETS for Multiple GROUP BY Queries in a Single Query
- How to Setup MySQL Master Master Replication
- How To Use SQL to Convert a STRING to an INT
- How to set up MySQL Replication Tutorial
- How to Use SQL CASE for Conditional Logic in Your SQL Queries
- Using ISNULL in SQL Server to Replace NULL Values
- Using SQL COALESCE to Find the First Non-NULL Value
- How to Take a Backup of a Table in MySQL
- SQL Server 2016 New Features - Multiple TempDB Files Configured at Server Install
- Monitoring SQL Server Transaction Log Growth Using DBCC SQLPERF(logspace)
- SQL Server 2016 New Features - Live Query Statistics
- SQL Server 2016 New Features - Query Store
- SQL Server 2016 New Features - Always Encrypted
- SQL Server 2016 - What Are The New Features?
- How to Find I/O Usage Per Database in SQL Server
- How to Get SQL Server Developer Edition for Free
- How to List CPU Usage Per Database in SQL Server
- How to Find Buffer Pool Usage Per Database in SQL Server
- Revoking Access for All Users of a Database in SQL Server
- How to Determine Which Port MySQL is Running On
- Will solid state hard drives negate the need to performance tune your database server?
- SQL Server Certification - 2 for 1 exam offer
- SQL Server Virtual Labs saves you time and resource
- New T-SQL features in SQL Server 2012 - WITH RESULT SETS
- If you want to try SQL Azure, then this is how you can do it
- SQL Server covering index and key lookup performance
- SQL Server 2012 certification - part 2
- New T-SQL features in SQL Server 2012 - OFFSET and FETCH
- Get a SQL Server 2012 ebook for free!
- SQL Server 2012 certification
- Keeping fit could improve your performance as a DBA
- New T-SQL features in SQL Server 2012 - THROW
- 10 simple tips on improving query and server performance
- New T-SQL features in SQL Server 2012 - CREATE SEQUENCE
- New T-SQL features in SQL Server 2012 - Conversion Functions
- What are the differences between primary keys and unique indexes in SQL Server ?
- GROUPING SETS performance versus UNION performance
- Database views explained
- How to shrink tempdb
- SQL Server TempDb - what's it for?
- The importance of the foreign key constraint
- TempDB best practices
- Using sp_change_users_login to fix SQL Server orphaned users
- An Introduction to SQL Server Backup
- Differences Between TRUNCATE TABLE and DELETE
- Using DBCC FREEPROCCACHE to Clear SQL Server Procedure Cache
- The OLEDB Wait Type and How to Reduce It
- Have You Set Yourself Any Goals for the New Year?
- Reducing SQL Server CXPACKET Wait Type
- An Overview of SQL Server Task Scheduling
- An Introduction to SQL Server Wait Types and Stats
- How to Delete Millions of Rows using T-SQL with Reduced Impact
- Reset Table Identity Value Using DBCC CHECKIDENT RESEED
- How to move tempdb
- How to Transfer Logins to Another SQL Server or Instance
- How to Determine SQL Server Version Number In Various Ways
- Free Ebook Downloads
- Querying INFORMATION_SCHEMA
- Auditing SQL Server Logins
- SQL books that I frequently use
- SQL Server Error Log Consuming Lots of Disk Space
- Using DBCC INPUTBUFFER for SQL Server troubleshooting
- Using exec sp_who2 to help with SQL Server troubleshooting