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

Archives: November 2018

Dates and Times in SQL Server: DATEADD()

We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure SQL Database. This week we look at one of my favourite T-SQL functions when it comes to dates and times: DATEADD(). Syntax As with similar functions, DATEADD can do arithmetic… Read more

0 comments, 45 reads

Posted in Born SQL with Randolph West on 14 November 2018

Power BI Monthly Digest – November 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our November 2018 edition we highlighted the following features:

    • Expand and Collapse Matrix
    • New Filter Experience (preview)

Read more

0 comments, 37 reads

Posted in Devin Knight on 14 November 2018

Azure SQL Database – Fixing My Scaling Failure

This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I was confused, so confused that I ended up logging a support request with Microsoft. The issue was I wanted to … Continue reading

Read more

0 comments, 47 reads

Posted in All About SQL on 14 November 2018

T-SQL Tuesday #108: New Horizons Beyond SQL Server

There comes a point in one’s career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change. Maybe the change is an entirely new career field. Maybe the change is adapting to the ever improving features of a… Read more

0 comments, 85 reads

Posted in SQL RNNR on 13 November 2018

Learning Better Presentation Skills (T-SQL Tuesday #108)

This month’s T-SQL Tuesday is hosted by Malathi Mahadevan (@SqlMal). The topic is to pick one thing I would like to learn that is not SQL Server.

I’m going to go a different direction than I think most people will. I spend a lot of time learning… Read more

0 comments, 73 reads

Posted in Data Savvy on 13 November 2018

Deploying SQL Server Availability Groups in Kubernetes

In this blog post, we’re going to work on deploying a SQL Server Availability Group in a Kubernetes Cluster in on-premises virtual machines. I’m going to walk you through the process as it’s documented by Microsoft at this link here. This document is very good but only shows you… Read more

0 comments, 101 reads

Posted in Anthony Nocentino's Blog on 13 November 2018

Audit Database Offline Events

Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we may not find out about an event for a few days or weeks and then we are asked to figure out… Read more

0 comments, 106 reads

Posted in SQL RNNR on 13 November 2018

T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108

Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a broad range of knowledge in an area that may not be overly deep and one or more spikes of deeper knowledge. I have to admit, up to this point my… Read more

4 comments, 81 reads

Posted in SQLStudies on 13 November 2018

Why did my execution plan change?

As a SQL Server DBA it is important to understand why and how the SQL engine works.  Understanding as much as you can with the engine can help you answer some questions from application developers, like why did my execution plan change suddenly?

Execution plans change as the optimizer see’s… Read more

0 comments, 99 reads

Posted in vitamindba on 13 November 2018

Bert & Pinal Troubleshoot a Slow Performing SQL Server

What happens when you run into performance tuning expert Pinal Dave?  Talk about how to troubleshoot a slow performing SQL Server of course!

This week is all about the video, so if you can’t view it above, head on over to my YouTube channel to watch it there. Read more

2 comments, 84 reads

Posted in Bert Wagner on 13 November 2018

Drive space check SQL server steps and scripts

Following is the script used for drive space related issues.

--SQL 2000
-- select name,(size/128.0) as size_mb,* from master.dbo.sysaltfiles order by size_mb desc

-- To check the drive free space

------------------------------- get all the db file info & filter the drive, mdf/ldf
select db_name(a.database_id) as DBname,a.name as DBfile ,…

Read more

0 comments, 78 reads

Posted in SQL Server Blog Forum on 13 November 2018

Random Pix from the 2018 PASS Summit

A few memories from me. First, a beautiful late arrival view.

My first session feels a little lonely

It started to fill a bit later

A few selfies, Angela






and my view during a break after Thursday’s sessions.

Where’s my room?

It’s a wrap

After… Read more

0 comments, 146 reads

Posted in The Voice of the DBA on 12 November 2018

Part 1: Predictive Modeling using R and SQL Server Machine Learning Services

To R or not to R?

A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research, I found that R is regarded as more old-school and difficult to learn, but Python is more popular. It made perfect… Read more

2 comments, 146 reads

Posted in SQL Roadie on 12 November 2018

Speaking At SQL Saturday DC

I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018.

I will be presenting two sessions, What is Power BI? and Data Types Do Matter.  My Data Types Do Matter session is the same session that I presented at… Read more

0 comments, 80 reads

Posted in SQL Swimmer on 12 November 2018

Bad Query Performance Tips Rebutted

Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over the internet, over and over. Even worse, sometimes the tips are copied or edited incorrectly, making a bad suggestion even worse. Can we please, stop copying this list? I’ve tried… Read more

4 comments, 108 reads

Posted in The Scary DBA on 12 November 2018

A New Video - Create a DB Executor Role

A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There is a reader and a writer role but no execute role. So if you wanted a role that allowed you grant execute to all stored procedures and functions in a…

Read more

0 comments, 70 reads

Posted in The SQL DBA in the UK on 12 November 2018

Load and run custom T-SQL scripts in SSMS via Snippets

If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have stored them on a folder and you open them manually as you need them, or have saved them on a solution…

Read more

1 comments, 89 reads

Posted in SQL Guatemala on 12 November 2018

Notes From the 2018 PASS Summit (v20)

This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like in another 20 years?

Notes from this year:

  • Flew out on Monday, uneventful. Arrived in Seattle around 1130 and was able to get my room right away at the Motif.…

Read more

3 comments, 81 reads

Posted in SQLAndy on 12 November 2018

Reasons to Serve on the PASS Board of Directors

A few weeks back I wrote Some Thoughts on How To Prepare to Serve on the PASS Board of Directors. The responses I heard, especially during the Summit last week, had two themes:
  • Recommending that much preparation will deter many candidates from running/is the bar for serving really that high?

Read more

0 comments, 90 reads

Posted in SQLAndy on 11 November 2018

Getting Started with Installing Kubernetes On-Prem

Let’s get you started on your Kubernetes journey with installing Kubernetes on premises in virtual machines. 

Kubernetes is a distributed system, you will be creating a cluster which will have a master node that is in charge of all operations in your cluster. In this walkthrough we’ll create three workers… Read more

0 comments, 119 reads

Posted in Anthony Nocentino's Blog on 11 November 2018

Older posts