@SQLLive360 profile picture
SQL Server Live! @SQLLive360

An event for IT pros & DBAs that provides education on #SQLServer database management, performance tuning and troubleshooting - Dec 2-7, 2018

Joined February 2012
  • Tweets 3,790
  • Following 197
  • Followers 923
68 Photos and videos
From #Live360 speaker @SQLRockstar: 7 things you don't want to do when designing a #database ow.ly/p3Ck30lLgIn
1
1
.@jdanton on 5 #SQLServer components you should be using (via @RedmondIT) ow.ly/ThzA30lGf0e
#Azure #SQL Database high availability (via @JamesSerra) ow.ly/h5Rw30lBPYy
1
#SQLServer tip: remember the default window (via @way0utwest) ow.ly/A1LQ30lwYSx
Managing your active #SQLServer instance list using #PHP (via @MSSQLtips) ow.ly/Kvs430lqbVI

Managing your active SQL Server instance list using PHP

In this tip we will look at a simple way to manage your list of SQL Server instances using PHP and SQL Server.

mssqltips.com
Generate a script in #SQLServer in 6 simple steps ow.ly/KoLB30lkbuv
How to turn on/enable Instant File Initialization (IFI) in #SQLServer (via @PinalDave) ow.ly/H01O30ld1P5

SQL SERVER - How to Turn On / Enable Instant File Initialization? - SQL Authority with Pinal Dave

This blog post is a follow-up blog post on the subject of Instant File Initialization (IFI). I suggest you read the following blog posts before you continuing this blog post. Today we will learn how...

blog.sqlauthority.com
1
Data Masker for #SQLServer and temporal tables (via @way0utwest): ow.ly/1pYP30l17Vh
1
Q&A with @vickyharp on the state of #SQLServer tools development (via @RedmondIT) ow.ly/MTxr30kUoRy

Q&A: The State of SQL Server Tools Development -- Redmondmag.com

Microsoft's SQL Server toolbox is a complicated ecosystem, and differentiating one tool from another is a challenge. Vicky Harp, lead program manager of the SQL Server tools team, clarifies Microso...

redmondmag.com
#SQLServer tip: revoke the permissions before dropping the server principal (via @DBA_ANDY) ow.ly/uikP30kLGZ1
Overview of #SQLServer2017 #Docker containers on #Linux machines (via @SQLServerCentrl) ow.ly/ayyS30kF9OC
#SQLServer tip: adding values with the keywords WITH OVER and PARTITION BY (via @PinalDave) ow.ly/wzvf30kzmaU

SQL SERVER - Adding Values WITH OVER and PARTITION BY - SQL Authority with Pinal Dave

Once in a while, I get questions where users have indeed explained the question well enough that I can easily understand their question. If I understand question quickly, I am always able to answer...

blog.sqlauthority.com
#TSQL starter statistics package for #SQLServer (via @MSSQLtips): ow.ly/xYOj30kpKwC

T-SQL Starter Statistics Package for SQL Server

In this tip we cover several different T-SQL scripts to help you get started with statistics for SQL Server data.

mssqltips.com
The future isn't in databases, but in #data (via @SQLRockstar) ow.ly/8G8030kl1ef
Query optimization techniques in #SQLServer: the basics (via @SQLShack) ow.ly/dhbl30kg663

Query optimization techniques in SQL Server: the basics

In this blog pos we will talk about the basics of Query optimization techniques in SQL Server, and list some of them to have it handy.

sqlshack.com
1
8
#SQLServer tip: Simple script to create a login and user for a specific #database with system admin rights (via @PinalDave) ow.ly/VHIM30k4U9a
Analyzing #StackOverflow data directly and with #PowerBI (via @SQLRockstar): ow.ly/AjkO30jVhiy
#Containers: the future of #database infrastructure? (via @RedmondIT) ow.ly/KcO330jMvS1

Containers: The Future of Database Infrastructure? -- Redmondmag.com

Databases usually lag behind other servers in moving to new architecture, but containerization brings enough major improvements to convince even the most old-school DBAs.

redmondmag.com
Provisioning #SQLServer instances with #Docker (via @Simple_Talk): ow.ly/OTkQ30jIS3j

Provisioning SQL Server Instances with Docker

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.

red-gate.com
1
1
Execution plan shortcoming in #SQLServer Extended Events (via @GFritchey): ow.ly/cLkc30jFbXa

Execution Plan Shortcoming in Extended Events - Grant Fritchey

I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for getting the time and resources used by a query. They can be filtered,...

scarydba.com
1
Load more