Today's Topic

From SQL Server Wiki
Jump to: navigation, search

What did you learn or study today?

December 2017[edit]

Title URL Discovered on date/day
Making Choices sqlservercentral.com 2017-12-15 Friday
Database Fundamentals #15: Modifying Data With T-SQL - Grant Fritchey scarydba.com 2017-12-11 Monday

November 2017[edit]

Title URL Discovered on date/day
Long Live OLE DB! timmitchell.net 2017-11-20 Monday

October 2017[edit]

Title URL Discovered on date/day
Overview of business continuity with Azure SQL Database docs.microsoft.com 2017-10-16 Monday
How to Log Wait Stats to Table with sp_BlitzFirst brentozar.com 2017-10-13 Friday
How to Do a SQL Server Architecture Review brentozar.com 2017-10-12 Thursday
SQL Server Diagnostic Information Queries for October 2017 sqlskills.com 2017-10-06 Friday

September 2017[edit]

Title URL Discovered on date/day
SQL Server Wait Types Library sqlskills.com 2017-09-21 Thursday
Creating Basic Indexes on the Stack Overflow Public Database brentozar.com 2017-09-07 Thursday
Should You Enforce Foreign Key Relationships in the Database? brentozar.com 2017-09-01 Friday

August 2017[edit]

Title URL Discovered on date/day
Things Your SQL Server Monitoring Software Should Tell You https://www.brentozar.com/archive/2017/08/things-sql-server-monitoring-software-tell 2017-08-31 Thursday
24HOP Summit Preview PowerShell ❤️ SQL Server Modern Database Administration youtube.com 2017-08-03 Thursday
Ingest data from a web page into SQL Server 2017 using R mssqltips.com 2017-08-03 Thursday
Performance Myths : Oversizing string columns sqlperformance.com 2017-08-02 Wednesday

July 2017[edit]

Title URL Discovered on date/day
Export data from SQL Server to Excel mssqltips.com 2017-07-05 Wednesday

June 2017[edit]

Title URL Discovered on date/day
Replace Bad Characters in Table sqlservercentral.com 2017-06-28 Wednesday
dbfs – command line access to SQL Server DMVs centinosystems.com 2017-06-28 Wednesday
Improving Replication voiceofthedba.com 2017-06-26 Monday
SQL Server KIT github.ccom 2017-06-23 Friday
Microsoft SQL Server Utilities and Tools sqlservercentral.com 2017-06-22 Thursday
UNION ALL Optimization sqlperformance.com 2017-06-13 Tuesday
Measuring SQL Query Performance matthewmcgiffen.com 2017-06-08 Thursday

May 2017[edit]

Title URL Discovered on date/day
Restore to a point in time–#SQLNewBlogger voiceofthedba.com 2017-05-26 Friday
How to document multiple SQL Server databases using SQL Doc and PowerShell red-gate.com 2017-05-23 Tuesday
Quick Graph Database voiceofthedba.com 2017-05-12 Friday
Why is a Windows authenticated login more secure than a SQL authenticated one? sqlstudies.com 2017-05-08 Monday
Performance Tuning Using Extended Events: Part 3 - SQLServerCentral sqlservercentral.com 2017-05-04 Thursday

April 2017[edit]

Title URL Discovered on date/day
App Compatibility with SQL Server on Linux | Data Exposed | Channel 9 channel9.msdn.com 2017-04-27 Thursday
SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server(): XML PATHs Of Glory bradsruminations.blogspot.com 2017-04-26 Wednesday
Generating HTML from SQL Server Queries - Simple Talk simple-talk.com 2017-04-26 Wednesday
Weaning yourself off of SQL Profiler (Part 1) - Wayne Sheffield blog.waynesheffield.com 2017-04-25 Tuesday
Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools sqldbawithabeard.com 2017-04-05 Wednesday

March 2017[edit]

Title URL Discovered on date/day
3 Mistakes I Made While Presenting Remotely - Cathrine Wilhelmsen cathrinewilhelmsen.net 2017-03-31 Friday
Getting SQL Server File Sizes and Space Used with dbatools sqldbawithabeard.com 2017-03-29 Wednesday
How do you clear the SQL Server transaction log? - Stack Overflow stackoverflow.com 2017-03-27 Monday
Insufficient Disk Space (T-SQL Tuesday #88) sqlservercentral.com 2017-03-27 Monday
The $650 SQL Saturday new comments voiceofthedba.com 2017-03-24 Friday
Interview - Brent Ozar - Mohammad Darab mohammaddarab.com 2017-03-13 Monday
Execution Plan Basics simple-talk.com 2017-03-10 Friday
The Big Red Button thedailywtf.com 2017-03-10 Friday
How to work with the command line in Azure SQL Data Warehouse sqlservercentral.com 2017-03-09 Thursday
Create a DACPAC to Move Databases voiceofthedba.com 2017-03-08 Wednesday
The Migration Checklist (comments) sqlservercentral.com 2017-03-08 Wednesday
The $650 SQL Saturday voiceofthedba.com 2017-03-07 Tuesday
Detective Stories - Tracking Down the Database's Dependents Part 2 sqlservercentral.com 2017-03-07 Tuesday
Finding the Worst Performing TSQL Statement databasejournal.com 2017-03-06 Monday
Project Bletchley - The Microsoft Vision for Blockchain eventbrite.com 2017-03-06 Monday

February 2017[edit]

Title URL Date and day of the week
sql - MySQL combine two columns into one column - Stack Overflow stackoverflow.com 2017-02-23 Thursday
Install SQL Server on Ubuntu | Microsoft Docs docs.microsoft.com 2017-02-23 Thursday
Back to Basics: Capturing Baselines on Production SQL Servers sqlservercentral.com 2017-02-21 Tuesday
Using EXCEPT to Determine Row Differences sqlservercentral.com 2017-02-17 Friday

January 2017[edit]

Title URL Date and day of the week
SQL Server Blog blogs.technet.microsoft.com 2017-01-23 Monday
The (Former) Complexity of PowerShell voiceofthedba.com 2017-01-19 Thursday
What is COPY_ONLY? sqlservercentral.com 2017-01-19 Thursday
Kevin Hill - YouTube youtube.com 2017-01-13 Friday
Backing Up SQL Server Databases is Easier in PowerShell than T-SQL sqlservercentral.com 2017-01-12 Thursday
Deploy & Manage Ola Hallengren's Scripts in SQL Server with PowerShell - YouTube youtube.com 2017-01-12 Thursday
Bitnami makes deploying open source apps in the cloud easy open.microsoft.com 2017-01-10 Tuesday
An Introduction to SQL Server Containers sqlservercentral.com 2017-01-08 Sunday
Voice of the DBA voiceofthedba.com 2017-01-06 Friday
Raspberry Pi • View topic - VAX/VMS on RaspberryPi raspberrypi.org 2017-01-05 Thursday
Starting with Chocolatey voiceofthedba.com 2017-01-03 Tuesday



Previous Topics[edit]

Today's Topic - Earlier


What Links Here[edit]