Greetings & Salutations!
sheldonhull.com
All Tags

sql-server

117

117 posts tagged with sql-server across 9 years (2013ā€“2021)

2021 1 post

2020 5 posts

2019 2 posts

2018 2 posts

2017 19 posts

Implicit Transactions

Redgate SQL Data Compare & Devart DBForge Data Compare

SSMS 2016 - Object Explorer Read Uncommitted

Track Creation of Databases

2016 41 posts

Get Backup History for All Databases in Server

Fixing Untrusted Foreign Key or Check Constraint

Centralized Management Server 101

Fixing non-deterministic error when creating indexed view

SQL 2016 - Configuration Manager Not Showing in Start Menu

SQL 2016 - Brief Overview on some new features

Does sp_rename on a column preserve the ms_description?

Improvements with SSMS 2016

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

Failed to Initialize SQL Agent Log... not worthy

Calculating Some Max Mirror Stats

Failover all databases to other server

Easy way to test log shipping or availability groups setup

Transaction Logging & Recovery (part 3)

Verifying Instant File Initialization

Transaction Logging & Recovery (part 2)

Transaction Logging & Recovery (101)

2015 25 posts

Model needs exclusive lock

Dynamic SQL & Quotename

XML Attribute VS Element Assignment when working with SQL

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

Brentozar''s Training: Chocolate & Cowboy Hats Included

Monitoring SQL Server on a budget

Stranger Danger... The need for trust with constraints

Using Qure Profiler To Benchmark Tuning Progress

SET NOEXEC is my new friend

Running very large scripts is not a strong area for SSMS

Database Stuck in Single-User Mode Due to Botched Restore

What was I thinking? Deleting myself from localdb?

Some simple examples of querying xml with sql

Enabling Instant File Initialization

Upgrade from SQL 2014 Evaluation to Developer Edition

Restoring a database that doesn't exist

Statistics Parsing

Dev Tools: The File Searcher/Launcher to rule them all

Case of the Mondays... causing me to randomly redefine the Scope of Global

2014 7 posts

OR pattern causing indexing scans in parameter based queries

Get Information on Current Traces Running

Generate Random Date With Starting Point

Snippet Alert: Useful dates (eom, bom, etc)

Eliminate Overlapping Dates

Finding Groups - Consecutive Months

Scalar functions can be the hidden boogie man

2013 15 posts

Renaming all references inside stored procedures and functions can be migraine worthy without a little help...

Shortcut to reference examples, syntax, and definitions straight from SSMS

Check Constraints can help enforce the all or nothing approach when it comes

TSQL Snippet for viewing basic info on database principals and their permissions

A moment of void in the cranium reveals a recursive computed column with an

View computed columns in database

Get synonym definitions for all databases in server

Calculating the next beginning of month and the current end of month

Installing SSMS 2012 all by it's lonesome

snippet designate a certain time of the day in getdate()

dynamic sql and a char crash

How to default SSRS date parameters to the first and last day of the the previous month

Related Tags

cool-tools (29) tech (21) powershell (17) dbatools (7) redgate (7) performance-tuning (4) influxdb (4) development (3) docker (2) devops (2)