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

Archives: April 2017

Still time to enter the SQL Clone contest

You could win an Amazon Echo from Redgate. Our contest is still open for a few days, so post a comment on my blog and take your chances. I’ll be picking from the comments next week.


Filed under: Blog Tagged: Redgate, SQL Clone, syndicated

Read more

0 comments, 409 reads

Posted in The Voice of the DBA on 26 April 2017

PowerShell Function – Validating a Parameter Depending On A Previous Parameter’s Value

I was chatting on the SQL Community Slack with my friend Sander Stad b | t about some functions he is writing for the amazing PowerShell SQL Server Community module dbatools. He was asking my opinion as to how to enable user choice or options for Agent Schedules and… Read more

0 comments, 254 reads

Posted in SQL DBA With A Beard on 26 April 2017

Something something Production something something you idiot

You’re reading this series of posts because you want to learn about databases and how to use them. What you should not be doing is learning about databases and how to use them, while working inside a production environment. Also called “prod”, because we’re lazy, this server (or servers) is… Read more

0 comments, 18 reads

Posted in Born SQL with Randolph West on 26 April 2017

QA, Utility Databases, and Job Executions

Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation are different; there will always be several different ways in most cases that you can arrive at a solid solution.

 

This post has a few intentions behind it:

  • It…

Read more

0 comments, 234 reads

Posted in The SQL Professor on 26 April 2017

SQL PowerShell 2017 IS HERE!

Cue Princess Jasmine.

What do I mean “Cue Princess Jasmine”?
Well because starting today, it’s a “Whole New World for You & Me”

What on Earth am I talking about??
The SqlServer PowerShell is now available for download in the PowerShell Gallery! http://sqlps.io/sqlserver

What Does It Mean!?

It means that… Read more

0 comments, 1,912 reads

Posted in SQLvariant on 26 April 2017

Why is a Windows authenticated login more secure than a SQL authenticated one?

I had this question come up at work the other day and while I knew it was true I wasn’t as sure about why as I’d like. The person I was working with wanted a real answer, not just Because I say so, so off to the internet I… Read more

9 comments, 2,892 reads

Posted in SQLStudies on 26 April 2017

SQLBits Review

I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find it useful (even though it was 2 weeks ago!) To start with I always wanted to go to a SQLBits … Continue reading

Read more

2 comments, 283 reads

Posted in All About SQL on 26 April 2017

SQL Server 2016: A Comprehensive Introduction – Arabic

It has been over a year since I have blogged, I know… that’s a long time!  I have not retired, but rather focused on other parts of my life and career and I hope to get back to blogging.  One of my major focuses for the last year was a…

Read more

0 comments, 222 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 26 April 2017

Pausing index rebuilds in SQL Server 2017

Last week Microsoft confirmed that the name of SQL vNext will indeed be SQL Server 2017. I was looking through the documentation for more info on Adaptive Query Processing as I wanted to write a post on adaptive joins but then I saw: –

To see the new Adaptive Join… Read more

1 comments, 1,280 reads

Posted in The DBA Who Came In From The Cold on 26 April 2017

Pausing index rebuilds in SQL Server 2017

Last week Microsoft confirmed that the name of SQL vNext will indeed be SQL Server 2017. I was looking through the documentation for more info on Adaptive Query Processing as I wanted to write a post on adaptive joins but then I saw: –

To see the new Adaptive Join… Read more

1 comments, 102 reads

Posted in The DBA Who Came In From The Cold on 26 April 2017

Updating TSqlModels (DacFx)

This one is for the DacFx nuts out there, it can't be a very big club but judging from the occasional emails I get about it, the quality is very high ha ha.

If you have a TSqlModel and you want to make a change to it, you have a…

Read more

0 comments, 196 reads

Posted in Ed Elliott's Sql Developer Blog on 26 April 2017

Something you didn't know about validating full-text indexing

My favourite way to compare technical experience with others is to ask them about the ways in which something can fail. Anyone can recite BOL but it's edge-case knowledge that shows a DBA has been hardened through trench warfare. After all if you've seen my talk about operational validation,… Read more

0 comments, 29 reads

Posted in Cody Konior on 26 April 2017

Speaking at 24 Hours of PASS

On May 3, 2017, at 2 PM EDT (6 PM GMT) I’ll be speaking as part of the 24 Hours of PASS. Here’s what I’ll be speaking on:

 

Protecting Data Across the Environment

You are responsible for protecting data within your organization. Wary of how attackers have become… Read more

0 comments, 252 reads

Posted in Databases – Infrastructure – Security on 25 April 2017

Power BI Custom Visuals Class (Module 48 – Time Brush)

In this module you will learn how to use the Time Brush Power BI Custom Visual.  The Time Brush gives you the ability both filter your report and see a graphics representation of your data at the same time. The name Time Brush comes from the behavior used when you… Read more

0 comments, 1,139 reads

Posted in Devin Knight on 25 April 2017

Quick Script: Finding Specific Columns

I like scripts.  Scripts that help me do things.

Working in the financial industry, there are always things that you have to ensure are protected.  More specifically, social security number and date of birth.

If your environment is like most, there are legacy applications that have a database behind the… Read more

0 comments, 1,277 reads

Posted in John Morehouse | Sqlrus.com on 25 April 2017

Can a Data Professional Be Organized?

“One of the advantages of being disorderly is that one is constantly making exciting discoveries.”  While this quote is true it is often times too late to act on an opportunity therefore it is missed. If you are a leader at your respective shop it can then be conceived that… Read more

0 comments, 1,141 reads

Posted in The SQL Professor on 25 April 2017

SSIS Training for Summer 2017

This summer, I will be delivering my popular full-day training class Building Better SSIS Packages in three different cities across the southern United States: Thursday, June 1st: Pensacola, Florida Friday, June 16th: Pasadena, Texas (just outside of Houston) Friday, July 14th: Lawrenceville, Georgia (near Atlanta) This course is designed for… Read more

0 comments, 229 reads

Posted in Tim Mitchell on 25 April 2017

Food On Your Table

I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially said no. I mean after all, it’s just training and networking that could lead to improved knowledge and abilities which… hang on. Just how wrong I can be sometimes when… Read more

1 comments, 255 reads

Posted in The Scary DBA on 25 April 2017

Redgate: SQL Search

I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially when your environment has thousands of objects. Upon some research I found a Redgate tool that is free called SQL … Continue reading

Read more

0 comments, 264 reads

Posted in All About SQL on 25 April 2017

My SQL Server Development Team Maturity Levels

A teams maturity shows in its choice of tools.

I have seen quite a few different development teams in wildly different environments and the single fact that really stands out is that you can tell how good a team is by the tools that they use. It isn't always the…

Read more

0 comments, 1,202 reads

Posted in Ed Elliott's Sql Developer Blog on 24 April 2017

Newer posts

Older posts