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

Latest Blog Posts

Removing an Azure SQL Database using PowerShell..

In this post we will remove some databases located in Azure.

This related to my last post where I am cleaning up some badly named databases and replacing them with standardised database names.

So we have this situation:

We want to get rid of the top two databases AzureWebAppFunctionalTestDB and… Read more

0 comments, 44 reads

Posted in The Hybrid DBA's Blog on 30 April 2017

Creating an Azure SQL Database via PowerShell

This post is about using the brilliance of PowerShell to script the creation of databases in Azure.

Background:

Apart from the obvious question of why not? The actual reason is one of standards and how I did not adhere to my own standards that I’ve been preaching for the past… Read more

1 comments, 50 reads

Posted in The Hybrid DBA's Blog on 30 April 2017

Multiple usage of functions to ensure “value” is not null?!

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts NULLs. The code is given in the next screen shot.

ScreenShot 1. The query with three functions on OriginalAmount

As you… Read more

0 comments, 58 reads

Posted in Si vis pacem, para sql on 29 April 2017

GroupBy–Bringing DevOps to the Database

Today was my presentation in the April GroupBy conference lineup. I presented on DevOps and changing your database development to include more agile, DevOps, flexible development practices.

If you want to get the deck, the slides are here: BringingDevOpstotheDatabase.pptx.

The video is also up on the GroupBy Youtube channel Read more

2 comments, 147 reads

Posted in The Voice of the DBA on 28 April 2017

[Off-Topic] Dealing with Type 2

I had a brief conversation with Stuart Ainsworth yesterday over Facebook. In passing I mentioned that I was doing well managing blood sugar levels and he indicated he didn’t know I had been dealing with anything like that. It reminded me that I hadn’t said anything about being diagnosed with… Read more

0 comments, 74 reads

Posted in Databases – Infrastructure – Security on 28 April 2017

A Couple Weeks until VS Live–Austin

VS Live takes place in Austin on May 15-18, 2017. This is a great conference in a fun city. It’s a full stack event, with the change to learn about cloud computing, ALM/DevOps, SQL, and Visual Studio, all at the same event. You can move from room to room and… Read more

0 comments, 130 reads

Posted in The Voice of the DBA on 28 April 2017

Friday Reading 2017-04-28

Nearly May! Although it’s been snowing this week in Dublin so summer still appears to be a while off…

Community driven Enhancements in SQL Server 2017
The MS Tiger Team list the new features in SQL 2017 that have been built based on feedback from the community

SQL Server 2017… Read more

0 comments, 79 reads

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

Friday Reading 2017-04-28

Nearly May! Although it’s been snowing this week in Dublin so summer still appears to be a while off…

Community driven Enhancements in SQL Server 2017
The MS Tiger Team list the new features in SQL 2017 that have been built based on feedback from the community

SQL Server 2017… Read more

0 comments, 11 reads

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

SSDT Dev in Visual Studio Code

I have been quite interested by vs code and have been using it more and more recently. I use it for all my GO (#golang FTW) work and also powershell and I have been toying with the sql tools team's sql extension which is great. For a long time I…

Read more

0 comments, 98 reads

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

DBA 101: Tuning lookups

Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.

Microsoft has a lot of great resources discussing these topics, though I thought I’d take a… Read more

0 comments, 99 reads

Posted in Confessions of a Microsoft Addict on 27 April 2017

Speaking at Syntax Code and Craft Conference 2017

On May 18, 2017, I’ll be giving a talk at the Syntax Code and Craft Conference in Charleston, SC. If you haven’t heard of this conference, it’s a 2-day affair primarily focused on developers. Here is my talk:

 

MAKE SQL SERVER GO FASTER

An app is a failure if… Read more

0 comments, 156 reads

Posted in Databases – Infrastructure – Security on 27 April 2017

New Course: Understanding and Using Azure SQL Database

At SQLskills, we just launched our new training class on Azure that I will be teaching in Chicago, and my course on Azure SQL Database was just published on Pluralsight too! While I am sharing awesome news, we also launched our new 3 day training class on upgrading SQL Server Read more

0 comments, 102 reads

Posted in Tim Radney - Database Professional on 27 April 2017

24 Hours of PASS is coming up!

Another installment of 24 Hours of PASS is coming up next week on May 3-4! This semiannual event features 24 back-to-back webinars on a certain theme. The theme this time is data security and data quality, a subject I’m passionate about.

I’m happy to say that I get to present… Read more

0 comments, 85 reads

Posted in The Data Files on 27 April 2017

Limiting the Max–#SQLNewBlogger

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

I was chatting with someone the other day about MAX() and how it can work within a set of rows, rather than across an entire result set. That’s… Read more

0 comments, 133 reads

Posted in The Voice of the DBA on 27 April 2017

SSIS – Adding Connections

Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run into something like this I am going to write a quick blog about it.  It’s something new I’m trying

While recently examining an existing SSIS package  before implementing some needed… Read more

0 comments, 69 reads

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

Amt als PASS Regionalgruppenvertreter in Köln/Rheinland niedergelegt

Mit einigem Wehmut darf ich verkünden, dass ich das Amt des Regionalgruppenvertreters (RGV) der PASS Regionalgruppe Rheinland niedergelegt habe. Seit Januar 2011 bin ich RGV gewesen – also für ziemlich genau 6 Jahre.

  • Für die Noch-Nicht-PASS’ler die kurze Anmerkung: Die PASS Deutschland (e.V. um genau zu sein) ist ein…

Read more

Speaking at the SSWUG 2017 Spring Virtual Conference

On May 2, 2017, I’ll be giving two talks at the SSWUG 2017 Virtual Conference. Here are the talks:

 

Building a Home Grown Auditing Infrastructure for SQL Server

Not everyone has the budget for 3rd party tools to provide audit / security information on their SQL Server environment.… Read more

0 comments, 74 reads

Posted in Databases – Infrastructure – Security on 26 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, 148 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, 88 reads

Posted in SQL DBA With A Beard 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, 84 reads

Posted in The SQL Professor on 26 April 2017

Older posts