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

Archives: February 2018

Offline installation of SQL Server 2017 on Linux

SQL Server is now compatible with different Linux distributions, and there is a lot of excitement about it.
How ever one of the main questions when ever you say SQL Server 2017 is now supported in Linux is, Have you test it? how do you install it?

By looking in…

Read more

0 comments, 829 reads

Posted in SQLDbaInternals on 28 February 2018

PASS Summit 2018 – Call for Speakers

It is that time again. PASS has opened the Call for Speakers. I have submitted for the past 10 years, and have been selected the past 7 years. This was such an important milestone in my career to be selected and then to present. Making sure I know what… Read more

0 comments, 324 reads

Posted in The Smiling DBA on 28 February 2018

Using the Full Screen Mode in SSMS (Day 33)

Do you ever find yourself working on a query and realize that you need just a bit more real estate in the SSMS window? Or perhaps you find that all the toolbars, menus, etc. are cluttering things up? To solve these issues, you can toggle the full screen mode in… Read more

1 comments, 302 reads

Posted in A Discussion of SQL Server-Related Topics on 28 February 2018

Precons in Richmond, Philadelphia and New York

I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I get the opportunity to do a precon at a SQLSaturday event. Well, I’ve got three coming up.

All three are an all day session entitled “SQL Server Tools for Query… Read more

4 comments, 1,517 reads

Posted in The Scary DBA on 28 February 2018

A day in the life of a Sr DBA/Dev

If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points in your career (if not quite daily).

There’s a bug in my code,
Dear Liza, dear Liza,
There’s a bug in my code,
Dear Liza, a bug.

So fix it, Read more

0 comments, 264 reads

Posted in SQLStudies on 28 February 2018

SQL in the City is Live

You can watch on YouTube now: https://www.youtube.com/watch?v=0qyMutBkZsg

If you want slides and notifications, register on the Redgate hub.

We’re recording the sessions and they’ll be available whenever you have time to watch, but join us today. We’re live.

The keynote is done, with more sessions to come today.

Read more

0 comments, 712 reads

Posted in The Voice of the DBA on 28 February 2018

A gotcha when switching partitions

When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of data from one table to another as a META DATA ONLY operation is absolutely fantastic.

What’s also cool is that we can switch data into a non-partitioned table. Makes life… Read more

1 comments, 1,928 reads

Posted in The DBA Who Came In From The Cold on 28 February 2018

Dates and Times in SQL Server: SMALLDATETIME

Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds, DATETIME. But let’s say you don’t need that kind of accuracy and are happy with a granularity to the nearest minute. Maybe you’re storing time… Read more

2 comments, 855 reads

Posted in Born SQL with Randolph West on 28 February 2018

Blocking Locks and Deadlocks

Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock occurs when one lock causes another process to wait until the current process is entirely done with the resources. Deadlocks Consider the situation where one partially finished transaction must wait… Read more

0 comments, 78 reads

Posted in SQL Treeo on 28 February 2018

Doing DevOPs for your Database? You need to start here…

I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…

In fact it was when I first joined Jade Software that I realised that Ops and DEV had a common interest in making systems go. In 2002 I started working… Read more

3 comments, 1,010 reads

Posted in The Hybrid DBA's Blog on 28 February 2018

New Built-in Function STRING_AGG() – SQL Server 2017

SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am going to discuss one of the built-in aggregate functions – “STRING_AGG()”.

The function concatenates values from rows as one value with a separator, and the main advantage is it… Read more

2 comments, 4,443 reads

Posted in SQL Geek on 28 February 2018

Typing Alternative Characters

I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one language and most of my work has been with US centric industries. I’ve rarely had the need to deal with Unicode and most of my databases have used varchar() everywhere.… Read more

1 comments, 338 reads

Posted in The Voice of the DBA on 27 February 2018

Adaptive Joins

I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So, I figured I could do a quick overview.

Adaptive Join Behavior

Currently the adaptive join only works with columnstore indexes, but according to Microsoft, at some point, they will also… Read more

3 comments, 953 reads

Posted in The Scary DBA on 27 February 2018

How to make a Database Request

You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s  just that the database is slow. I’m going to let you in on the secret of the best method to get what you want out of your DBA. Ready? Here’s the secret… Ask… Read more

1 comments, 327 reads

Posted in SQL Awesomesauce on 27 February 2018

Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!

Planning to Increase Cost Threshold for Parallelism

When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see SQL Server creating and using execution plans with parallelism. The instance configuration “cost threshold for parallelism” is what determines for SQL Server the minimum…

Read more

8 comments, 900 reads

Posted in Eitan Blumin on 27 February 2018

Productivity For The Data Pro

Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate within the traditional 9-5 office job but the nature of working around databases requires flexibility; and, the focus is shifting constantly minute by minute. One moment you’re looking at something… Read more

0 comments, 273 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 27 February 2018

Splitting It Up: Side by Side Queries In SSMS

There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc…

If using two monitors you can have a query window on each as a reference, or you can resize two query window tabs so… Read more

0 comments, 148 reads

Posted in Bert Wagner on 27 February 2018

Who installed SQL Server?

Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent requirement to patch the physical box from Windows team.

As the server was not in production, so the server entry was missing. Since Windows team wanted to take action on… Read more

2 comments, 1,930 reads

Posted in SQL Geek on 27 February 2018

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We all know technology changes so quickly so there is no shortage of topics!  There is a list of all my presentations with slide decks.  Here are the new presentations I… Read more

3 comments, 45 reads

Posted in James Serra's Blog on 26 February 2018

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We all know technology changes so quickly so there is no shortage of topics!  There is a list of all my presentations with slide decks.  Here are the new presentations I… Read more

3 comments, 589 reads

Posted in James Serra's Blog on 26 February 2018

Older posts