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

Archives: November 2018

My Book Contributions

It’s a Wonderful Life

One of the really super cool things about the SQL community is the frequent opportunity one could have to get involved.

One of my favorite methods of getting involved is the varied ways to participate on a book project. To be involved in a book project… Read more

0 comments, 252 reads

Posted in SQL RNNR on 30 November 2018

Information Measurement with SQL Server Part 4.3: Euclidean Distance and the Minkowski Family

By Steve Bolton

…………“The shortest distance between two points is a straight line.”
…………In this famous remark, Archimedes[1] (287-212 B.C.) managed to sum up all of the uses for Euclidean Distance, i.e. the way that laymen and data scientists ordinarily use to measure ranges of space on a… Read more

0 comments, 1,765 reads

Posted in Multidimensional Mayhem on 30 November 2018

Things I Learned at Summit v20 - Trace Flag 4199

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post we'll look at a trace flag I had never even heard of, let alone deployed - 4199.

What is a Trace Flag?  According to Microsoft:
Trace flags…

Read more

1 comments, 2,440 reads

Posted in Nebraska SQL from @DBA_ANDY on 29 November 2018

SQL in the City December 2018

The last 2018 edition of SQL in the City Streamed is coming in a few weeks. You can register today and join us for a set of talks on December 12 that talk DevOps, compliance, and more.

I have to deliver the keynote, which I’m working on now, taking information… Read more

0 comments, 348 reads

Posted in The Voice of the DBA on 29 November 2018

Take the State of DevOps Survey

Kendra wrote a nice piece on this the other day, and I agree.

Take the Survey

The data that comes out of this helps to influence executives and managers. You can show them results, which might get them to help you change your job.

This is also a way that… Read more

0 comments, 331 reads

Posted in The Voice of the DBA on 29 November 2018

Data Professionals at Work Book

Working as a Data Professional

An old friend Malathi Mahadevan (b | t) asked me one day if I would be interested in helping with her first book project. Anybody who has participated in the writing of a book knows this can be a rather daunting task –… Read more

0 comments, 232 reads

Posted in SQL RNNR on 29 November 2018

SQL Server Guide To NULL Handling

Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite nasty unexpected results.

In some languages NULL == NULL will be true and in others it will be false, SQL has a couple of caveats around this to be aware… Read more

0 comments, 3,071 reads

Posted in Gavin Draper's SQL Server Blog on 29 November 2018

New Resumable Online Index Create SQL Server 2019

SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of my favorite new things. This paired with the Resumable Index Rebuilds introduced with SQL Server 2017 really gives database administrators much more control over index processes.

Have you ever started… Read more

4 comments, 2,135 reads

Posted in SQLEspresso on 28 November 2018

Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

A good habit to get into is to explicitly name your constraints. I try to do this when I create tables to be sure that a) I have… Read more

1 comments, 2,835 reads

Posted in The Voice of the DBA on 28 November 2018

Price increase for Azure in Canadian dollars

On 1 December 2018, Microsoft is increasing Azure subscription prices in Canadian dollars by 5%. The following is taken directly from the email I received on 1 November 2018. Starting December 1, 2018, prices for Azure services in the Canadian dollar will increase by 5 percent to more closely align… Read more

0 comments, 223 reads

Posted in Born SQL with Randolph West on 28 November 2018

A curious case of case when and Null values

For some reason I have always written my Case statements using the following logic:

	WHEN @Priority = 1 THEN 'Very High'
	WHEN @Priority = 2 THEN 'High'
	WHEN @Priority = 3 THEN 'Medium'
	WHEN @Priority = 4 THEN 'Low'


It wasn’t until recently that… Read more

5 comments, 2,720 reads

Posted in SQL Undercover on 28 November 2018

How to be an MVP Book

How to be an MVP in LIFE

One of the fun things about being involved in the community is the opportunity to meet new people. Sometimes, meeting new people leads to new opportunities. Most of the time, those meetings turn into friendships of varying degrees.

One person I met at… Read more

1 comments, 273 reads

Posted in SQL RNNR on 28 November 2018

Oh Query, Query, Query

I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.

I have a little query
I wrote it in a day
And when it’s fixed and ready
My query I shall run

Oh, query, query, query
I wrote it in… Read more

1 comments, 2,736 reads

Posted in SQLStudies on 28 November 2018

Early Bird SQL Bits Pricing

You can register today and save for the next few days. It’s only £799 for the full SQL Bits 2019 conference until Saturday. If you’ve ever  been, you know this is the best SQL Server conference out there, at least, that’s how I feel, and I go to a lot… Read more

1 comments, 276 reads

Posted in The Voice of the DBA on 28 November 2018

Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell

30/11/2018 – Function has been updated to deal with named instances.

Last week the Tiger Team released their Availability Group Failover Detection Utility which will provide root cause analysis on Cluster Logs, SQL Error Logs, and the Availability groups extended events logs. There is a blog post here and the… Read more

10 comments, 1,849 reads

Posted in SQL DBA With A Beard on 28 November 2018

Midlands PASS Meetings for January and February 2019

Midlands PASS won’t be holding a meeting in December. Too much going on! However, we are hosting meetings in January and February.

January 8, 2019 – Moving Data with Azure Data Factory

Andy Leonard (twitter | website) joins us to discuss Azure Data Factory. Learn from one of… Read more

0 comments, 197 reads

Posted in Databases – Infrastructure – Security on 27 November 2018

Should I load structured data into my data lake?

With data lakes becoming very popular, a common question I have been hearing often from customers is, “Should I load structured/relational data into my data lake?”.  I talked about this a while back in my blog post What is a data lake? and will expand on it in this blog.… Read more

4 comments, 466 reads

Posted in James Serra's Blog on 27 November 2018

Auditing when Database Files Change

As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking when the data file(s) grow(s). Many will argue that there is nothing worse than not knowing when a database-related file changed… Read more

1 comments, 314 reads

Posted in SQL RNNR on 27 November 2018

Database Stuck in Suspect Mode

My holiday week did not started off very good.  I come in and find a UAT environment database in suspect mode.  Having a database in suspect mode means a few different things could have happened.  Some of the reasons why a databases goes to suspect mode are:

  1.  Files associated to…

Read more

0 comments, 241 reads

Posted in vitamindba on 27 November 2018

Brute Forcing SQL Logins and Passwords

Watch this week’s episode on YouTube.

Following up on last week’s post about the different types of SQL injection, this week I want to show how injection can be used to obtain a SQL login and its password.

My goal with today’s post is to show how easy… Read more

0 comments, 332 reads

Posted in Bert Wagner on 27 November 2018

Older posts