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

Latest Blog Posts

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, 113 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, 132 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, 113 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, 105 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, 216 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

4 comments, 167 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, 92 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

9 comments, 129 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, 82 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

2 comments, 98 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, 97 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, 107 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, 131 reads

Posted in Anthony Nocentino's Blog on 11 November 2018

Last week reading (2018-11-11)

Hello folks, how are you today? It was a very comprehensive week and many of my friends returned home after PASS Summit. As always, PASS Summit is the event where you can hear many announcements. This post, predominantly, base on them. Unfortunately, I did attend the event this year, but… Read more

0 comments, 6 reads

Posted in SQL Player Blog on 11 November 2018

Happy Veterans Day to my SQL Brothers and Sisters!

Thank you all for your service!

I was fortunate to have attended PASS Summit again this year. As an added bonus they had a Birds of a Feather luncheon table for Veterans every day. I sat at the table every day and met a number of different veterans from all… Read more

0 comments, 94 reads

Posted in cjsommer.com on 11 November 2018

PASS Summit Cosmos DB Demo Code

As part of the PASS Summit conference session that Bob Pusateri and I are presenting right now called “Cosmos DB for SQL Server Pros“, we are demonstrating a number of Azure Cosmos DB features that we feel strongly about helping you leverage through code. As a result, all… Read more

0 comments, 111 reads

Posted in Technobabble by Klee from @kleegeek on 9 November 2018

Vote for the PASS Board of Directors

Voting is open for the PASS Board of Directors. It’s a non-event this year, with three open positions and three candidates. That’s disappointing, as I would hope to see new candidates, new blood, and some change in the organization. I’m not complaining, since I didn’t run, but I hope that… Read more

0 comments, 310 reads

Posted in The Voice of the DBA on 9 November 2018

Refresh SQL Modules

As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be visibly represented as the wrinkles on your face. Other times, as with SQL Server, it may mean that a stored procedure or view stops working.

Unfortunately, when it comes to… Read more

0 comments, 647 reads

Posted in SQL RNNR on 9 November 2018

Ethics in Data Science and Artificial Intelligence

Microsoft redid its Data Science Track not too long ago and they added several courses and new progress points. One of those progress points is Apply Ethics and Law in Analytics and the course to cover this point is Microsoft DAT249x: Ethics and Law in Data and Analytics, offered… Read more

0 comments, 757 reads

Posted in Databases – Infrastructure – Security on 8 November 2018

Live blog: Women in Technology lunch at #PASSSummit #passwit

11:48am This will be starting shortly! We’re stuffing our faces, first. Today’s featured speaker is Lauri Bingham, Director of Technology Engineering Project Management at T-Mobile (LinkedIn). Let’s go! 12:15pm Wendy Pastrick, PASS Executive VP, opens the show. This is the 16th annul WIT luncheon at PASS Summit. And now, Lauri… Read more

2 comments, 112 reads

Posted in SQL Awesomesauce on 8 November 2018

Newer posts

Older posts