sql-server - Tag - sheldonhull.com

sql-server

2021

Understanding The Basics of SQL Server Security 2021-06-24

2020

SQL Server Meets AWS Systems Manager 2020-12-16

Azure Data Studio SQL Notebook for Diagnostic Queries 2020-06-24

2020-06-04T22:15:21+00:00 2020-06-04

2020-05-07T22:54:34+00:00 2020-05-07

Running SQL Server in Docker 2020-01-16

2019

Getting Started With Python For Data Exploration 2019-11-19

SQL Server Database Experimentation Assistant - How to Run a Capture 2019-02-07

2018

NTFS Compression and SQL Server Do Not Play Well Together 2018-08-08

SQL .NET Requirements 2018-03-30

2017

Exploring SQL Server With Powershell And SMO Basics 2017-08-09

Capturing Perfmon Counters With Telegraf 2017-08-08

InfluxDB and Annotations 2017-08-07

Dataedo - First Look 2017-08-07

ANTS Performance Profiler for the SQL Server Dev 2017-07-21

Update SSMS With PS1 2017-07-03

External Tool VSCODE called from SQL Management Studio 2017-06-26

Best Practices: Defining Explicit Length for Varchar/Nvarchar 2017-06-07

Powershell Module Improvements for SQL Server in 2017 2017-05-31

Running InfluxDB as a service in Windows 2017-05-24

Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev 2017-05-17

Automate Windows Updates for Development 2017-05-10

Red Gate SQL Clone (1) - Initial Setup 2017-02-27

Track Creation of Databases 2017-02-18

SSMS 2016 - Object Explorer Read Uncommitted 2017-02-18

Redgate SQL Data Compare & Devart DBForge Data Compare 2017-02-18

Quick Way to Run Powershell Tasks in Parallel 2017-02-18

Bad Idea Jeans: Query Optimization Through Minification 2017-01-23

2016

Dynamically Set Powershell Variables from json 2016-12-05

Attaching Database Using SMO & Powershell 2016-11-18

Parallel Powershell for Running SQL 2016-11-16

Get Backup History for All Databases in Server 2016-11-01

Data Compare on Temporal Tables 2016-10-28

Fixing Untrusted Foreign Key or Check Constraint 2016-10-22

Easy SQL Maintenance with Minionware 2016-10-18

Cannot Generate SSPI Context 2016-10-17

Centralized Management Server 101 2016-10-16

Migrating Database Collation - The Red Gate Way 2016-10-10

Fixing non-deterministic error when creating indexed view 2016-10-09

SQL 2016 - Configuration Manager Not Showing in Start Menu 2016-09-21

Setting DBCC 1222 on startup 2016-09-19

Remote Desktop Workflow Improvements 2016-08-29

SSMS - Connection Color with SQL Prompt & SSMSBoost 2016-08-23

SQL 2016 - Brief Overview on some new features 2016-08-19

Install ReadyRoll via Command Line 2016-08-18

Does sp_rename on a column preserve the ms_description? 2016-08-15

Regex With SQL Server - SQLSharp 2016-08-11

Improvements with SSMS 2016 2016-07-12

Glasswire: (Giveaway Included) Networking Monitoring even a caveman could 2016-07-01

SQL Compare 12: Initial Look 2016-06-26

SSMS Tools Pack - A Handy Tool for generating CRUD 2016-06-17

OmniCompare: A free tool to compare SQL Instances 2016-06-14

Continual Deployment of Visual Studio SqlProj 2016-05-16

The Mysterious Black Box of R - For the SQL Server Guy 2016-05-15

Red Gate Dependency Tracker - Making Databases Into Moving Art 2016-04-28

Automating SSMS 2016 Updates & Install 2016-04-27

Cool Tools: Powershell ISE-Steroids 2016-04-14

Failed to Initialize SQL Agent Log... not worthy 2016-04-01

TFS Work-Item Fancy Filtering 2016-03-18

SQL 2012 SP3 and entity framework conflict 2016-03-18

Previewing the new SSRS 2016 portal 2016-03-18

Failover all databases to other server 2016-03-18

Calculating Some Max Mirror Stats 2016-03-18

Easy way to test log shipping or availability groups setup 2016-01-29

Diff All Files - Reviewing Changesets Quickly 2016-01-25

Transaction Logging & Recovery (part 3) 2016-01-20

Verifying Instant File Initialization 2016-01-13

Transaction Logging & Recovery (part 2) 2016-01-08

Transaction Logging & Recovery (101) 2016-01-05

2015

Model needs exclusive lock 2015-12-15

Documenting Your Database with Diagrams 2015-12-09

Best Tools for Taking Notes In Development 2015-10-14

Dynamic SQL & Quotename 2015-09-23

XML Attribute VS Element Assignment when working with SQL 2015-09-21

Split personality text editing in SSMS with Sublime Text 3 2015-09-14

Multi-Cursor Editing SQL feels like the movie Inception just became real 2015-09-10

Brentozar''s Training: Chocolate & Cowboy Hats Included 2015-08-27

Monitoring SQL Server on a budget 2015-08-18

Stranger Danger... The need for trust with constraints 2015-08-13

Red Gate SQL Source Control v4 offers schema locks 2015-08-12

Using Qure Profiler To Benchmark Tuning Progress 2015-08-10

SET NOEXEC is my new friend 2015-08-07

Running very large scripts is not a strong area for SSMS 2015-08-05

Database Stuck in Single-User Mode Due to Botched Restore 2015-07-28

What was I thinking? Deleting myself from localdb? 2015-07-13

Some simple examples of querying xml with sql 2015-06-24

Enabling Instant File Initialization 2015-05-22

Upgrade from SQL 2014 Evaluation to Developer Edition 2015-05-04

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace... 2015-04-30

SQL Sentry Pro Explorer is worth it... 2015-04-28

Restoring a database that doesn't exist 2015-04-28

Statistics Parsing 2015-01-21

Dev Tools: The File Searcher/Launcher to rule them all 2015-01-13

Case of the Mondays... causing me to randomly redefine the Scope of Global 2015-01-05

2014

OR pattern causing indexing scans in parameter based queries 2014-12-11

Get Information on Current Traces Running 2014-12-02

Generate Random Date With Starting Point 2014-08-12

Snippet Alert: Useful dates (eom, bom, etc) 2014-08-11

Finding Groups - Consecutive Months 2014-05-19

Eliminate Overlapping Dates 2014-05-19

1
2