Today's Topic - Earlier

From SQL Server Wiki
Jump to navigation Jump to search

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

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

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

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

typeperf

2016-06-16[edit]

biml

2016-06-14[edit]

Write to File - SQLServerCentral

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:

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:

  1. 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
  2. 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]