Year archive
Posts from 2016
Blog posts
- Community Influencer of the Year
- TSQL Tuesday #85: Backup + Recovery + ☁️
- December SQLSaturdays--DC & Providence, RI
- T-SQL Tuesday #83: Roundup
- (Unofficial) PASS Summit 2016 LGBT Meetup
- We’re still dealing with the same problems
- T-SQL Tuesday #83: We're still dealing with the same problems
- Plan Explorer 3.0: More power and completely free
- Podcast: Mirroring, Availability Groups, Replication, and Log shipping
- Job hunting for database professionals
- Benefits tell you a lot about a company
- Job hunting is like dating
- Moving SSRS Reports between servers
- T-SQL Tuesday #79 - COMPRESS()ing LOB data
- Add-Equals operator
- SSMS Template Replacement
- T-SQL Tuesday #78– sys.dm_db_file_space_usage
- My 5th DBAnniversary
- How to shrink a database in 4 easy steps
- CONVERT() to float using scientific notation
- How fast queries hurt performance
- T-SQL Tuesday #77– My favorite SQL Server feature
- Shortcuts Cheat Sheet - SSMS & Windows
- Decoding sql_handle
- Data Compression: How page compression works
- xp_sqlagent_enum_jobs alternative
- Data Compression: How row compression works
- Speaking at #SqlSatChi - SQL Saturday #484 in Chicago
Stack Exchange answers
- Stack Exchange answer: Does the 'reads' column in SQL Profiler mean the same as IOPS?
- Stack Exchange answer: What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology?
- Stack Exchange answer: How to add 1100 columns in SQL Server
- Stack Exchange answer: AlwaysON Migrate from 2014 to 2016
- Stack Exchange answer: Is it possible to change the family_guid in MSSQL?
- Stack Exchange answer: SQL Server 2014 slow insert
- Stack Exchange answer: Why is this explicit cast causing problems only with a Linked Server?
- Stack Exchange answer: Does it ever make sense to have a clustered and non clustered index for the same column
- Stack Exchange answer: I have 3 tables with dates to which I want to join to a date dimension table but it is returning many duplicates with left joins
- Stack Exchange answer: PowerShell can't see network locations after SQLPS module is loaded
- Stack Exchange answer: Why is sql_text "select @@trancount" in open but sleeping transaction?
- Stack Exchange answer: What is the benefit of having multiple databases in the same Availability Group vs single AG per database
- Stack Exchange answer: Will a SELECT . . . INTO use short-circuit evaluation for a COALESCE?
- Stack Exchange answer: Microsoft sql server management studio (SSMS) shortcut for changing size of sql/result panes
- Stack Exchange answer: Users in SQL Server cluster
- Stack Exchange answer: ReportServerTempDB in AlwaysOn Availability group
- Stack Exchange answer: Exclude All Matching Rows
- Stack Exchange answer: Convert row into concatenated string with column names included
- Stack Exchange answer: SQL Server: How to export database with linked servers
- Stack Exchange answer: Reduce MDF file size
- Stack Exchange answer: Using DateTime Variable In Where Clause
- Stack Exchange answer: How to efficiently design MongoDB database for Uber-like application?
- Stack Exchange answer: How to configure SSIS in SQL Server AlwaysOn
- Stack Exchange answer: UFT to SQL Server conecction which is located at different domain
- Stack Exchange answer: After trying to restart moved database: Unable to open the physical file "D:\Data\MYDBNAME.MDF"
- Stack Exchange answer: Why is the MSDB database TRUSTWORTHY?
- Stack Exchange answer: UnShrunk SQL Server database restore which is larger than available disk space
- Stack Exchange answer: What's the deal with transactions in a stored procedure called by an SSRS report?
- Stack Exchange answer: Windows cluster failed over, but SQL instances didn't move
Months
December
- Community Influencer of the Year
- Stack Exchange answer: Does the 'reads' column in SQL Profiler mean the same as IOPS?
- Stack Exchange answer: What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology?
- TSQL Tuesday #85: Backup + Recovery + ☁️
- Stack Exchange answer: How to add 1100 columns in SQL Server
November
October
September
August
- Podcast: Mirroring, Availability Groups, Replication, and Log shipping
- Stack Exchange answer: Is it possible to change the family_guid in MSSQL?
- Stack Exchange answer: SQL Server 2014 slow insert
- Stack Exchange answer: Why is this explicit cast causing problems only with a Linked Server?
- Stack Exchange answer: Does it ever make sense to have a clustered and non clustered index for the same column
- Stack Exchange answer: I have 3 tables with dates to which I want to join to a date dimension table but it is returning many duplicates with left joins
- Stack Exchange answer: PowerShell can't see network locations after SQLPS module is loaded
- Stack Exchange answer: Why is sql_text "select @@trancount" in open but sleeping transaction?
- Stack Exchange answer: What is the benefit of having multiple databases in the same Availability Group vs single AG per database
- Stack Exchange answer: Will a SELECT . . . INTO use short-circuit evaluation for a COALESCE?
July
June
May
April
- How to shrink a database in 4 easy steps
- CONVERT() to float using scientific notation
- How fast queries hurt performance
- T-SQL Tuesday #77– My favorite SQL Server feature
- Stack Exchange answer: Users in SQL Server cluster
- Stack Exchange answer: ReportServerTempDB in AlwaysOn Availability group
- Stack Exchange answer: Exclude All Matching Rows
- Stack Exchange answer: Convert row into concatenated string with column names included
- Stack Exchange answer: SQL Server: How to export database with linked servers
- Stack Exchange answer: Reduce MDF file size
March
- Stack Exchange answer: Using DateTime Variable In Where Clause
- Stack Exchange answer: How to efficiently design MongoDB database for Uber-like application?
- Stack Exchange answer: How to configure SSIS in SQL Server AlwaysOn
- Stack Exchange answer: UFT to SQL Server conecction which is located at different domain
- Stack Exchange answer: After trying to restart moved database: Unable to open the physical file "D:\Data\MYDBNAME.MDF"
- Stack Exchange answer: Why is the MSDB database TRUSTWORTHY?
- Stack Exchange answer: UnShrunk SQL Server database restore which is larger than available disk space
- Shortcuts Cheat Sheet - SSMS & Windows
- Stack Exchange answer: What's the deal with transactions in a stored procedure called by an SSRS report?
February
January
No months selected. Select one or more months to show posts.
Tags
Availability Groups
- Stack Exchange answer: AlwaysON Migrate from 2014 to 2016
- Podcast: Mirroring, Availability Groups, Replication, and Log shipping
- Stack Exchange answer: What is the benefit of having multiple databases in the same Availability Group vs single AG per database
- Stack Exchange answer: ReportServerTempDB in AlwaysOn Availability group
- Stack Exchange answer: How to configure SSIS in SQL Server AlwaysOn
Azure
Backup & Recovery
Cloud
Data Compression
Dates & Time
DBA Database
Indexes
Log Shipping
Mirroring
MongoDB
MySQL
PASS
Performance
PowerShell
Professional Development
Querying
Replication
Shortcuts
SQL Agent
SQL Family
SQL Saturday
SQL Server
- Stack Exchange answer: How to add 1100 columns in SQL Server
- Stack Exchange answer: Is it possible to change the family_guid in MSSQL?
- Stack Exchange answer: Why is this explicit cast causing problems only with a Linked Server?
- Stack Exchange answer: Users in SQL Server cluster
- Stack Exchange answer: Exclude All Matching Rows
- Stack Exchange answer: Convert row into concatenated string with column names included
- Stack Exchange answer: SQL Server: How to export database with linked servers
- Stack Exchange answer: Reduce MDF file size
- Stack Exchange answer: UFT to SQL Server conecction which is located at different domain
- Stack Exchange answer: After trying to restart moved database: Unable to open the physical file "D:\Data\MYDBNAME.MDF"
- Stack Exchange answer: Why is the MSDB database TRUSTWORTHY?
SQL Tooling
SSIS
SSMS
SSRS
Summit
T-SQL
- TSQL Tuesday #85: Backup + Recovery + ☁️
- T-SQL Tuesday #83: Roundup
- T-SQL Tuesday #83: We're still dealing with the same problems
- Stack Exchange answer: Will a SELECT . . . INTO use short-circuit evaluation for a COALESCE?
- T-SQL Tuesday #79 - COMPRESS()ing LOB data
- Add-Equals operator
- T-SQL Tuesday #78– sys.dm_db_file_space_usage
- How to shrink a database in 4 easy steps
- CONVERT() to float using scientific notation
- T-SQL Tuesday #77– My favorite SQL Server feature
- Decoding sql_handle
T-SQL Tuesday
- TSQL Tuesday #85: Backup + Recovery + ☁️
- T-SQL Tuesday #83: Roundup
- We’re still dealing with the same problems
- T-SQL Tuesday #83: We're still dealing with the same problems
- T-SQL Tuesday #79 - COMPRESS()ing LOB data
- T-SQL Tuesday #78– sys.dm_db_file_space_usage
- T-SQL Tuesday #77– My favorite SQL Server feature
Transaction Logs
Windows
No tags selected. Select one or more to show posts.
Categories
Databases
- Stack Exchange answer: Does the 'reads' column in SQL Profiler mean the same as IOPS?
- Stack Exchange answer: What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology?
- TSQL Tuesday #85: Backup + Recovery + ☁️
- Stack Exchange answer: How to add 1100 columns in SQL Server
- December SQLSaturdays--DC & Providence, RI
- T-SQL Tuesday #83: Roundup
- T-SQL Tuesday #83: We're still dealing with the same problems
- Plan Explorer 3.0: More power and completely free
- Stack Exchange answer: AlwaysON Migrate from 2014 to 2016
- Podcast: Mirroring, Availability Groups, Replication, and Log shipping
- Stack Exchange answer: Is it possible to change the family_guid in MSSQL?
- Stack Exchange answer: SQL Server 2014 slow insert
- Stack Exchange answer: Why is this explicit cast causing problems only with a Linked Server?
- Stack Exchange answer: Does it ever make sense to have a clustered and non clustered index for the same column
- Stack Exchange answer: I have 3 tables with dates to which I want to join to a date dimension table but it is returning many duplicates with left joins
- Stack Exchange answer: Why is sql_text "select @@trancount" in open but sleeping transaction?
- Stack Exchange answer: What is the benefit of having multiple databases in the same Availability Group vs single AG per database
- Stack Exchange answer: Will a SELECT . . . INTO use short-circuit evaluation for a COALESCE?
- Job hunting for database professionals
- Moving SSRS Reports between servers
- T-SQL Tuesday #79 - COMPRESS()ing LOB data
- Add-Equals operator
- Stack Exchange answer: Microsoft sql server management studio (SSMS) shortcut for changing size of sql/result panes
- T-SQL Tuesday #78– sys.dm_db_file_space_usage
- How to shrink a database in 4 easy steps
- CONVERT() to float using scientific notation
- How fast queries hurt performance
- T-SQL Tuesday #77– My favorite SQL Server feature
- Stack Exchange answer: Users in SQL Server cluster
- Stack Exchange answer: ReportServerTempDB in AlwaysOn Availability group
- Stack Exchange answer: Exclude All Matching Rows
- Stack Exchange answer: Convert row into concatenated string with column names included
- Stack Exchange answer: SQL Server: How to export database with linked servers
- Stack Exchange answer: Reduce MDF file size
- Stack Exchange answer: Using DateTime Variable In Where Clause
- Stack Exchange answer: How to efficiently design MongoDB database for Uber-like application?
- Stack Exchange answer: How to configure SSIS in SQL Server AlwaysOn
- Stack Exchange answer: UFT to SQL Server conecction which is located at different domain
- Stack Exchange answer: After trying to restart moved database: Unable to open the physical file "D:\Data\MYDBNAME.MDF"
- Stack Exchange answer: Why is the MSDB database TRUSTWORTHY?
- Stack Exchange answer: UnShrunk SQL Server database restore which is larger than available disk space
- Stack Exchange answer: What's the deal with transactions in a stored procedure called by an SSRS report?
- Decoding sql_handle
- Data Compression: How page compression works
- xp_sqlagent_enum_jobs alternative
- Data Compression: How row compression works
- Speaking at #SqlSatChi - SQL Saturday #484 in Chicago
- Stack Exchange answer: Windows cluster failed over, but SQL instances didn't move
Events & Writing
People & Work
Tools & Automation
No categories selected. Select one or more to show posts.