Today's Topic - Earlier
Back to Today's Topic
December 2016[edit]
Title | URL | Date and day of the week |
---|---|---|
Extended Events for Tracking Backup and Restore Progress | sqlservercentral.com | 2016-12-28 Wednesday |
Office Hours Podcast - Brent Ozar Unlimited® | brentozar.com | 2016-12-27 Tuesday |
SQL Server 2014 Licensing Changes | brentozar.com | 2016-12-27 Tuesday |
Multi-Step Input Forms in ASP.NET MVC | simple-talk.com | 2016-12-09 Friday |
Validating a Set of Database Scripts using DLM Automation | voiceofthedba.wordpress.com | 2016-12-09 Friday |
Some Tips for Minimising the Pain of HTML Input Forms | simple-talk.com | 2016-12-09 Friday |
The Seven Sins against TSQL Performance | simple-talk.com | 2016-12-08 Thursday (published in 2012) |
Truncate tables with foreign keys | sqlservercentral.com | 2016-12-02 Friday |
November 2016[edit]
Title | URL | Date and day of the week |
---|---|---|
SQL Server on Linux: Boring - Home Of The Scary DBA | scarydba.com | 2016-11-28 Monday |
Wildcard Searches | sqlservercentral.com | 2016-11-21 Monday |
When was my index created or at least last updated? | sqlstudies.com | 2016-11-21 Monday |
Implementing a Custom Sort | sqlperformance.com | 2016-11-21 Monday |
Is JavaScript Single-Threaded? | simpletalk.com | 2016-11-04 Friday |
Set Statistics… Profile? | brentozar.com | 2016-11-03 Thursday |
Script All Logins / Users / and Roles | sqlservercentral.com | 2016-11-02 Tuesday |
List and Execute SQL Server Stored Procedures with PowerShell | mssqltips.com | 2016-11-02 Tuesday |
Analysis Services Lives On | sqlservercentral.com | 2016-11-01 Tuesday |
October 2016[edit]
Title | URL | Date and day of the week |
---|---|---|
8 Ways to Export SQL Results To a Text File | sqlservercentral.com | 2016-10-26 Wednesday |
dbatools - best practices and instance migration module | dbatools.io | 2016-10-25 Tuesday |
Store a file and Retrieve it in SQL Server | sqlservercentral.com | 2016-10-21 Friday |
MariaDB vs. Microsoft SQL Server Comparison | db-engines.com | 2016-10-21 Friday |
Where Do You Run Your R Scripts? | sqlservercentral.com | 2016-10-20 Thursday |
SQLCMD to export data in txt file | sqlservercentral.com | 2016-10-13 Thursday |
Bones of SQL - Practical Calendar Queries | sqlservercentral.com | 2016-10-13 Thursday |
Search for SQL Saturday sessions by specified key phrase - Wayne Sheffield | blog.waynesheffield.com | 2016-10-11 Tuesday |
The Free-Con Returns to Seattle | Voice of the DBA | voiceofthedba.wordpress.com | 2016-10-11 Tuesday |
Error Logging Gone Wild - SQLServerCentral | sqlservercentral.com | 2016-10-11 Tuesday |
Who the Devil Wrote This SQL Code? - Simple Talk | simple-talk.com | 2016-10-10 Monday |
Introducing the Set-based Loop - SQLServerCentral | sqlservercentral.com | 2016-10-07 Friday |
September 2016[edit]
Title | URL | Date and day of the week |
---|---|---|
SQL Server for Linux - Simple Talk | simple-talk.com | 2016-09-30 Friday |
PSYaml: PowerShell does YAML - Simple Talk | simple-talk.com | 2016-09-26 Monday |
Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator - SQLServerCentral | sqlservercentral.com | 2016-09-23 Friday |
Monitor up-time and connectivity with Powershell - SQLServerCentral | sqlservercentral.com | 2016-09-22 Thursday |
Reading the SQL Server log files using TSQL | mssqltips.com | 2016-09-20 Tuesday |
Foreign Keys in SQL Server (video) - Brent Ozar Unlimited® | brentozar.com | 2016-09-16 Friday |
Stairway to U-SQL Level 8: Joining Tables in U-SQL | sqlservercentral.com | 2016-09-15 Thursday |
The Bones of SQL - The Calendar Table - SQLServerCentral | sqlservercentral.com | 2016-09-08 Thursday |
Stairway to Exploring Database Metadata Level 2: Using the Dynamic Online Catalog to Solve Problems - SQLServerCentral | sqlservercentral.com | 2016-09-07 Wednesday |
Copying an on-premise Database to an Azure SQL Database | sqlservercentral.com | 2016-09-06 Monday |
The Copy Cat Poll (backup strategies) | sqlservercentral.com | 2016-09-02 Friday |
The Joys Of Migrating From SQL Server To MariaDB : Coding Ninja | codingninja.co.uk | 2016-09-01 Wednesday |
New Drop If Exists Syntax in SQL Server 2016 | mssqltips.com | 2016-09-01 Wednesday |
August 2016[edit]
Title | URL | Date and Day of the Week |
---|---|---|
5 Monitoring Queries for SQL Server | simple-talk.com | 2016-08-30 Tuesday |
Curious..about data (about page) | curiousaboutdata.com | 2016-08-30 Tuesday |
Formatting SQL Code – Part the Second | simple-talk.com | 2016-08-30 Tuesday |
Query Performance Tuning – A Methodical Approach - SQLServerCentral | sqlservercentral.com | 2016-08-26 Friday |
Install ReadyRoll via Command Line | sheldonhull.com | 2016-08-26 Friday |
SQL Server Access Control: The Basics - Simple Talk | simple-talk.com | 2016-08-25 Thursday |
What is the impact of setting SET ANSI_WARNINGS OFF? | sqlservercentral.com | 2016-08-23 Tuesday |
Upload files to DropBox from PowerShell - Laurent Kempé | laurentkempe.com | 2016-08-19 Friday |
Why Not Just Create Statistics? - Brent Ozar Unlimited® by Brent Ozar Unlimited® | brentozar.com | 2016-08-18 Thursday |
PowerShell is open sourced and is available on Linux | Blog | Microsoft Azure | azure.microsoft.com | 2016-08-18 Thursday |
Simple T-SQL Code Comparison With PowerShell | mssqltips.com | 2016-08-16 Tuesday |
Module 11 - Calendar Visualization - YouTube | youtube.com | 2016-08-16 Tuesday |
SQL Saturday Distances, A Closer Look | 36 Chambers - The Legendary Journeys: Execution to the max! | 36chambers.wordpress.com | 2016-08-10 Wednesday |
SQL Awesomesauce - Feasel’s Grand Analysis of the PASS 600 mile radius rule | sqlservercentral.com | 2016-08-10 Wednesday |
Feasel’s Grand Analysis of the PASS 600 mile radius rule | The MidnightDBA Star-Times | midnightdba.com | 2016-08-10 Wednesday |
What is the Lambda Architecture? - SQLServerCentral | sqlservercentral.com | 2016-08-08 Monday |
Modifying Tables Online - Part 1: Migration Strategy | Michael J. Swart | michaeljswart.com | 2016-08-08 Monday |
Analyzing Data in Real Time - Page 2 | sqlservercentral.com | 2016-08-01 Monday |
IDERA Community | community.idera.com | 2016-08-01 Monday |
Unit Testing discussion: | sqlservercentral.com | 2016-08-01 Monday |
Quick Scalar Tables–#SQLNewBlogger | Voice of the DBA | voiceofthedba.wordpress.com | 2016-08-01 Monday |
Slimmer SQL Saturdays | Voice of the DBA | voiceofthedba.wordpress.com | 2016-08-01 Monday |
July 2016[edit]
Title | URL | Date |
---|---|---|
RFC 3339 - Date and Time on the Internet: Timestamps | tools.ietf.org | 2016-07-22 Friday |
SQL Server differences of char, nchar, varchar and nvarchar data types | mssqltips.com | 2016-07-21 Thursday |
Speakers: O'Reilly Artificial Intelligence Conference, September 26 - 27, 2016, New York | conferences.oreilly.com | 2016-07-20 Wednesday |
List all permission in all databases | sqlservercentral.com | 2016-07-20 Wednesday |
The Remote DBA - SQLServerCentral | sqlservercentral.com | 2016-07-18 Monday |
Shining Light on Non-Public Data Flows | ICSI | www.icsi.berkeley.edu | 2016-07-18 Monday |
Using the new SQLServer Powershell module to get SQL Agent Job Information - SQLServerCentral | sqlservercentral.com | 2016-07-14 Thursday |
The COUNT Function in T-SQL - SQLServerCentral | sqlservercentral.com | 2016-07-12 Tuesday |
5 Monitoring Queries for SQL Server | simple-talk.com | 2016-07-07 Thursday |
Using sp_executesql | voiceofthedba.wordpress.com | 2016-07-07 Thursday |
How To Survive A Database Disaster - Thomas LaRock | thomaslarock.com | 2016-07-06 Wednesday |
Daily Format[edit]
2016-08-25 Thursday[edit]
SQL Server Access Control: The Basics - Simple Talk
2016-08-23 Tuesday[edit]
What is the impact of setting SET ANSI_WARNINGS OFF?
2016-08-19 Friday[edit]
Upload files to DropBox from PowerShell - Laurent Kempé
2016-08-18 Thursday[edit]
Why Not Just Create Statistics? - Brent Ozar Unlimited® by Brent Ozar Unlimited®
PowerShell is open sourced and is available on Linux | Blog | Microsoft Azure
Simple T-SQL Code Comparison With PowerShell
- Simple T-SQL Code Comparison With PowerShell
2016-08-16 Tuesday[edit]
Module 11 - Calendar Visualization - YouTube Published on Aug 8, 2016
- In this module you will learn how to use the Calendar Visualization Power BI Custom Visual (https://app.powerbi.com/visuals/). The Calendar Visualization is a very unique visual that allows you to show the distribution of values across a calendar.
- https://www.youtube.com/watch?v=3dP5mCjmAAs&feature=youtu.be
2016-08-08 Wednesday[edit]
SQL Saturday Distances, A Closer Look | 36 Chambers - The Legendary Journeys: Execution to the max!
SQL Awesomesauce Feasel’s Grand Analysis of the PASS 600 mile radius rule
- http://www.sqlservercentral.com/blogs/sql_awesomesauce/2016/08/01/feasels-grand-analysis-of-the-pass-600-mile-radius-rule/
- http://www.midnightdba.com/Jen/2016/08/feasels-grand-analysis-of-the-pass-600-mile-radius-rule/#respond
2016-08-08 Monday[edit]
What is the Lambda Architecture? - SQLServerCentral
Modifying Tables Online - Part 1: Migration Strategy | Michael J. Swart
2016-08-01 Monday[edit]
Analyzing Data in Real Time - Page 2
IDERA Community
Unit Testing discussion:
Quick Scalar Tables–#SQLNewBlogger | Voice of the DBA
Slimmer SQL Saturdays | Voice of the DBA
2016-07-22 Friday[edit]
RFC 3339 - Date and Time on the Internet: Timestamps
2016-07-21 Thursday[edit]
SQL Server differences of char, nchar, varchar and nvarchar data types
2016-07-20 Wednesday[edit]
Speakers: O'Reilly Artificial Intelligence Conference, September 26 - 27, 2016, New York
List all permission in all databases
2016-07-18 Monday[edit]
The Remote DBA - SQLServerCentral
"JustMarie (7/18/2016)
However my boss's boss has a thing about 'butts in seats' and likes to see his people busily typing away and talking on phones.
This kind of attitude drives me insane, but (I think) it also points to insecure management. They don't trust their workforce, or they don't feel empowered to manage any issues that might arise from their employees working from home, so they just dictate that everybody must be visible at all times instead. A good manager should judge their employee on the quality of their work, not the vague observation that they're always at their desk. It's insane.
Preaching to the choir here. That attitude is about 15 years out of date. And it's going to cost them future talent when they're told that they have to be in the office 100% of the time. The underlying assumption you point out - that they can't trust their employees to work if they're not in the office - comes out very clear when telecommuting is taken off the table for no reason."
Shining Light on Non-Public Data Flows | ICSI
2016-07-14-Thursday[edit]
Using the new SQLServer Powershell module to get SQL Agent Job Information - SQLServerCentral
2016-07-12-Tuesday[edit]
The COUNT Function in T-SQL - SQLServerCentral
2016-07-07 (Friday)[edit]
5 Monitoring Queries for SQL Server
2016-07-07 (Thursday)[edit]
Using sp_executesql
2016-07-06 (Wednesday)[edit]
How To Survive A Database Disaster - Thomas LaRock
2016-06-30 (Thurday)[edit]
Is Resource Monitor (resmon) all I need to troubleshoot storage? - SQLServerCentral
- http://www.sqlservercentral.com/blogs/confessions-of-a-microsoft-addict/2016/06/23/is-resource-monitor-resmon-all-i-need-to-troubleshoot-storage/
- https://sqltechblog.com/2016/06/23/is-resource-monitor-resmon-all-i-need-to-troubleshoot-storage
2016-06-29 (Wednesday)[edit]
(from: http://sqldatapartners.com/podcast/ episode 48, with Tim Mitchell)
2016-06-27 (Monday)[edit]
The Desktop rebuild Part 2
First command:
@powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))" && SET PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin
2016-06-24 (Friday)[edit]
Voice of the DBA - have you ever build a database from scratch?
2016-06-22 (Wednesday)[edit]
Nice map of computer languages/tech:
2016-06-20 (Monday)[edit]
Comparing two query plans - SQLServerCentral
PowerShell One-Liners: Help, Syntax, Display and Files
Powershell Profiles:
2016-06-19[edit]
Get CPU Usage from Windows Command Prompt - Stack Overflow
2016-06-16[edit]
biml
2016-06-14[edit]
Write to File - SQLServerCentral
- http://www.sqlservercentral.com/scripts/ole/141060/
- http://www.sqlservercentral.com/Forums/Topic1785902-3401-1.aspx
2016-06-06 (Monday)[edit]
A New Sample Database - SQLServerCentral
Comment about what Sample Database to use:
"If you want a significant amount of data to use in test I recommend the stack exchange database as detailed in this blog post:
https://www.brentozar.com/archive/2014/01/how-to-query-the-stackexchange-databases/"
Unified Extensible Firmware Interface
- The Unified Extensible Firmware Interface is a specification that defines a software interface between an operating system and platform firmware. Wikipedia
2016-06-03 (Friday)[edit]
Accept Failure - Page 3
Interesting comment:
2016-06-02 (Thursday)[edit]
Consuming JSON Formatted API Data in 2016 - SQLServerCentral
I asked:
2016-06-01 (Wednesday)[edit]
GoToWebinar - Painting with PowerShell: SQL Server Administration
2016-05-31 (Tuesday)[edit]
EdVassie: Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,000 downloads.
2016-05-27[edit]
How to drop a table if it exists in SQL Server? - Stack Overflow
Adam Machanic
-I sent him a message about wikis
2016-05-24[edit]
Unified Approach to Generating Documentation for PowerShell Cmdlets
Web-Based Tracks Keeps Your GTD System in Order
2016-05-23[edit]
Database Hardware and Infrastructure Trends - SQLPerformance.com
SQL Server Diagnostic Information Queries
Automatically Creating UML Database Diagrams for SQL Server
Edward Tufte forum: Sparkline theory and practice Edward Tufte
2016-05-20[edit]
Natively Compiled Stored Procedures: What they are all about - SQLServerCentral
There are a lot of limitations
2016-05-18[edit]
SQL Server 2012 Build List - SQLServerCentral
2016-05-16[edit]
Links regarding table compares:
- https://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/05/how-to-get-the-tablediff-utility
- http://www.sqlservercentral.com/blogs/sqlstudies/2016/05/12/comparing-the-contents-of-two-tables/
- https://sqlstudies.com/2016/05/12/comparing-the-contents-of-two-tables/#comments
2016-05-13[edit]
Dateadd query plan issue
2016-05-12[edit]
Steve's recovery tools:
2016-05-11[edit]
SQL Server Central: Stairway to Server Management Objects (SMO) – a SQL Server tutorial
Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
SQL Server Central: Stairway to SQL PowerShell – a SQL Server tutorial
2016-05-10[edit]
How to look up metadata on different DBMS
2016-05-06[edit]
Indexing, unique versus non-unique
2016-05-04[edit]
I asked:
Execute Dynamic SQL:
Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout
Paul Ford: What is Code? | Bloomberg http://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/
2016-04-25[edit]
sp_Blitz® – Free SQL Server Health Check Script
Questions About PowerShell Basics That You Were Too Shy To Ask
2016-04-19[edit]
Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function
2016-04-19[edit]
I asked on SQL Server Central (4/19/2016)
- Has anyone set up 2 virtual machines on their desktop, one for browsing and email and one for everything else?
- Someone answered:
I use an Ubuntu VM for general browsing. With no shared folders
- I asked:
Is there a good guide to getting started somewhere?
Simple:
- install Virtual Box, Virtual Box can read Hyper-V, VMware and its own Virtual Box images. For non-production use, it a great way to get started with VM's
- download a pre-built Ubuntu image
If your VM engine is Virtual Box, make it easy, and choose the most current that has Guest Additions installed. Looks like that would be v. 13.04
Refer to this discussion:
2016-04-18[edit]
Unattended Installation
Powershell and SQL Server
Chrissy LeMaire @cl Cajun living in Belgium. PowerShell MVP. Mostly tweet about PowerShell, SQL Server, Belgian beer, Linux, and Infosec. PASS PowerShell Virtual Chapter Co-Lead. Brussels, Belgium blog.netnerds.net Joined March 2007
2016-04-11[edit]
Changing the sa Password with SSMS–#SQLNewBlogger – Voice of the DBA
The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters
2016-04-08[edit]
- Making a SQL Study plan (how long does it take to learn something in SQL)
2016-04-07[edit]
- How to set up Filezilla