-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2019

How many plans are in the plan cache for a stored procedure?

It depends on where you’re looking and how many statements are in the stored procedure.

Let’s take a look at some demos!

First, let’s create a stored procedure with multiple statements

USE StackOverflow2010
GO
CREATE OR ALTER PROCEDURE TestStatements (@Username NVARCHAR(100)) AS
BEGIN

SELECT Reputation FROM Users
WHERE DisplayName  =…

Read more

0 comments, 174 reads

Posted in Arthur's Blog on 31 January 2019

How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?

(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )

Today’s “Question of the Day” on SQL Server Central, Cleaning up the Identity, is about using DBCC CHECKIDENT to reset the seed value of an IDENTITY column to a specific starting value. The question asked what the… Read more

4 comments, 2,715 reads

Posted in SQL Quantum Leap on 31 January 2019

Azure Notebooks – a nice little tool.

Gday,

I’ve been playing with Azure notebooks lately and have found them invaluable as

  • A teaching aid
  • A test sandbox

I’ve been using Python code, and this means that I don’t have to install Python on the machine that I am working at.

It also means that anybody I am… Read more

0 comments, 1,075 reads

Posted in measure twice, cut once. on 31 January 2019

How To Check How Far Behind Your SQL Server Log Shipping Secondary Is

Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a different server/location. For the most part, you set it up and don’t need to touch it again, it just works. Out of the box the agent jobs SQL Server sets… Read more

0 comments, 2,625 reads

Posted in Gavin Draper's SQL Server Blog on 31 January 2019

Index maintenance freebies

I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log space to remove fragmentation.

Let’s talk about two things that SQL Server does for us: one statistic is created per index we create, and when we rebuild that index, we… Read more

3 comments, 2,345 reads

Posted in Arthur's Blog on 30 January 2019

Webinar next week on Database DevOps

Next week is my webinar on why the database is the heart of DevOps. You can still register today to discuss and debate why we need to ensure that database development is integrated into any DevOps work we do for other software.

Register: https://attendee.gotowebinar.com/register/3005019550714731265?source=KB

Read more

0 comments, 739 reads

Posted in The Voice of the DBA on 30 January 2019

Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULL
Image taken from 9gag.com
According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".

SQL Server implements the lack of value with NULL, that is datatype independent and indicates missing value, so the logical…

Read more

0 comments, 215 reads

Posted in SQL Guatemala on 30 January 2019

Speaking at SQLBits in March 2019

I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this year from 27 February to 2 March 2019. My session is called An overview of SQL Server 2019 for the busy DBA / developer. Here is the abstract: SQL Server… Read more

0 comments, 209 reads

Posted in Born SQL with Randolph West on 30 January 2019

See SQL Run

Note: I am perfectly aware of my ability as an artist so let the ribbing begin

Read more

5 comments, 212 reads

Posted in SQLStudies on 30 January 2019

Azure Advisor

Azure offers a lot of value-added services included with the price of what you pay . One of the things really, I like is Azure Advisor. this service provides information about your entire Azure landscape. It gives you a complete overview of your system needs including possible ways to save… Read more

0 comments, 253 reads

Posted in SQLEspresso on 30 January 2019

Azure Kubernetes Service Error – LoadBalancer type service external IP stays pending

Last week I was working on my Azure Kubernetes Service cluster when I ran into a rather odd issue. I’d created a service with a type of LoadBalancer in order to get an external IP to connect to SQL Server running in a pod from my local machine.

I’ve done… Read more

0 comments, 163 reads

Posted in The DBA Who Came In From The Cold on 30 January 2019

Backing Up and Restoring Your On-Premise Databases To and From the Cloud

I’ve been meaning to start a series of posts on “Dipping your toes into the cloud” for a while now, there are a number of things you can do to slowly take advantage of the cloud without having to re-architect your whole on-premise setup. This post will serve as part… Read more

0 comments, 160 reads

Posted in Gavin Draper's SQL Server Blog on 30 January 2019

Midlands PASS Meeting – February 5, 2019

Midlands PASS (Columbia, SC) will be hosting Shannon Lowder on February 5, 2019, from 5:30-8:00 PM. He will be speaking on his journey as a data scientist. If you are going to be in the area, here is the registration link:

https://www.eventbrite.com/e/becoming-a-data-scientist-tickets-53066926606

What’s the Talk About?

You’ve all heard about… Read more

0 comments, 130 reads

Posted in Databases – Infrastructure – Security on 29 January 2019

Storage options for SQL Server database files in Azure

If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf).  Most customers use managed disks, available in a number of offerings: Standard HDDStandard SSDPremium SSD, and… Read more

6 comments, 1,013 reads

Posted in James Serra's Blog on 29 January 2019

Opening a Twitch Channel, Data Wisdom

I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on Fridays, probably around 10AM. Topics will range from query tuning, to GDPR, to Redgate, to Azure Data Studio, pretty much the… Read more

2 comments, 177 reads

Posted in The Scary DBA on 29 January 2019

Query tuning: The IN clause

This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say that IN is better or worse than other T-SQL, I just want to showcase what it does.

We’ll jump right into the demos. I’m using StackOverflow2010 for this, and I’m… Read more

3 comments, 1,084 reads

Posted in Arthur's Blog on 29 January 2019

Cardinality: Not Just For The Birds

Watch this week’s episode on YouTube.

When building indexes for your queries, the order of your index key columns matters.  SQL Server can make the most effective use of an index if the data in that index is stored in the same order as what your query requires for… Read more

2 comments, 820 reads

Posted in Bert Wagner on 29 January 2019

Authentication considerations for your applications when migrating to Azure SQL Managed Instances

This blog post is related to my previous blog post on Azure SQL Managed Instances:

Azure SQL Managed Instance – full blown SQL Server in the cloud….?

Before you actually migrate your database you need to think about what changes to your application you may need to do.

Azure SQL… Read more

2 comments, 244 reads

Posted in The Hybrid DBA's Blog on 29 January 2019

Azure SQL Managed Instance – full blown SQL Server in the cloud….?

This blog post is one that I have had percolating in the background since around November 2018.

My good mate John Martin ( t ) was speaking at PASS Summit on Azure SQL Managed Instances and we had talked about use cases, some of the gotchas and things to consider… Read more

1 comments, 954 reads

Posted in The Hybrid DBA's Blog on 29 January 2019

Research into Autism in Information Technology

Title: Exploring the experiences of employees on the autism spectrum working in information technology: an interpretative phenomenological analysis


My name is Sabrina Ellis, I am the Operations Director here at GRE Solutions, I'm also a student at the University of Wolverhampton. The purpose of this post is to introduce the…

Read more

0 comments, 181 reads

Posted in The SQL DBA in the UK on 29 January 2019

Older posts