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

Archives: April 2017

Amt als PASS Regionalgruppenvertreter in Köln/Rheinland niedergelegt

Resigned from post as PASS Chapter Leader in Cologne/Rheinland

 

Mit einiger 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…

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, 405 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, 484 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, 327 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, 42 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, 305 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, 2,428 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, 3,058 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, 361 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, 279 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,506 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, 136 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, 269 reads

Posted in Ed Elliott's Sql Developer Blog 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, 9 reads

Posted in Ed Elliott's Sql Developer Blog 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, 10 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, 85 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, 290 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,267 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,367 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,269 reads

Posted in The SQL Professor on 25 April 2017

Newer posts

Older posts