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

Archives: March 2017

Using SQL Client Aliases

SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA setup process. If you haven’t seen it, it’s here.

One of the problems that we ran into when moving to using containers was how to get the applications to… Read more

1 comments, 338 reads

Posted in The DBA Who Came In From The Cold on 29 March 2017

Using SQL Client Aliases

SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA setup process. If you haven’t seen it, it’s here.

One of the problems that we ran into when moving to using containers was how to get the applications to… Read more

1 comments, 42 reads

Posted in The DBA Who Came In From The Cold on 29 March 2017

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Orange County)

on Apr 1st 1.30 pm, I will be presenting “consolidated essential performance health check using powershell” @ sqlsaturday, Orange County, if you are in the area I hope to see you…

location:
Golden West College, 15744 Goldenwest St,
Orange County, California, 92647, USA

sqlsaturday-Orange County 2016

event schedule

session details Read more

0 comments, 250 reads

Posted in SQLFeatures on 29 March 2017

SQL Server Database Recovery Process Internals – database STARTUP Command

A database recovery process is an essential requirement for database systems, It can be a tedious job and the process of recovery varies on a lot of scenarios. The desire to improve recovery results has resulted in various procedures but understood by few and prone to errors. In this article,… Read more

0 comments, 259 reads

Posted in PowerSQL By Prashanth Jayaram on 28 March 2017

SQLSaturday Madison – April 7-8

The first event I ever spoke at was SQLSaturday in Madison, Wisconsin, back in 2012. I was petrified – would anyone want to hear someone talk about normalization? Especially when that someone was pretty much unknown outside of his city? Long story short, yes, they did. I didn’t have a… Read more

0 comments, 225 reads

Posted in The Data Files on 28 March 2017

SQL Server 2016 – Always Encrypted and the GDPR

The European General Data Protection Regulation (GDPR) is coming, bringing new rules about the protection of Personally Identifiable Information (PII).

For those of us in Europe – or wishing to sell software products and solutions within Europe – this is a big deal. It’s going to mean an increased focus… Read more

3 comments, 1,895 reads

Posted in Matthew McGiffen DBA on 28 March 2017

Sharing With You In All Fifty States

I made a mistake the other day. For some reason I got it into my head that I was flying to Albuquerque when I was actually flying to Phoenix. I’ve no idea how or why that occurred, but I sent a tweet out on how excited I was to finally… Read more

1 comments, 251 reads

Posted in The Scary DBA on 28 March 2017

How is easy to work with JSON in SQL SERVER 2016 ?

If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t worry you might use sooner than later. JSON is kind of ecosystem which is most popular in the various area for exchanging the data. If you talk about charting solution,…

Read more

0 comments, 766 reads

Posted in Rajat Jaiswal-337252 on 28 March 2017

SQL Saturday South Island, New Zealand (SSSI)

G’day,

Saturday 8th April 2017 will see the biggest ever SQL Saturday South Island New Zealand. The event started in 2013 as SQL Saturday Christchurch and has progressively grown in size.

Originally run solely by the Christchurch SQL Server user group, the event expanded in 2015 in order… Read more

0 comments, 596 reads

Posted in measure twice, cut once. on 28 March 2017

Alter Datatype of All the Columns In Database

Requirement: Recently we got the information from management that our project will be getting the customers from China, so our application should support the Unicode characters. Now we support only English language, to support all the languages we decided to change all the char, varchar and text datatypes to nchar,…

Read more

0 comments, 39 reads

Posted in Help on SQL Server on 28 March 2017

Azure – SQL Database Premium RS

A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section and came across an edition that I had never seen before and I became very intrigued. It is called Premium … Continue reading

Read more

4 comments, 447 reads

Posted in All About SQL on 28 March 2017

A Perfect Solution to Resolve SQL Server Error 211

SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it becomes easy for a user to access the database in the more reliable and effective way. However, there are some situations such as destruction in… Read more

0 comments, 642 reads

Posted in Zora's SQL Tips on 28 March 2017

Data Channel - Interview 04 - Martin Catherall on In Memory OLTP

Welcome to the 4th Interview of Data Channel.
We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New Zealand discussing "In Memory OLTP" tables. Interview was shot at his wonderful home in Melbourne. I would like to thank Martin for sharing his knowledge for the SQL Community.…

Read more

1 comments, 195 reads

Posted in SQL and SQL Only on 27 March 2017

SQL Saturday 619. Join me April 29, 2017 in Rochester, NY and learn to Paint with PowerShell!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation… Read more

0 comments, 169 reads

Posted in cjsommer.com on 27 March 2017

Getting a VHD into Azure with PoSh

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

I thought this would make a nice SQLNewBlogger post, an easy get started one. I used the docs from Microsoft as a guide, so here’s how it… Read more

0 comments, 482 reads

Posted in The Voice of the DBA on 27 March 2017

sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, I’m sure all of you have been holding your collective breath but I finally have some new updates. I’m particularly excited about the @DropTempTables and @Output options.

Just as a… Read more

5 comments, 280 reads

Posted in SQLStudies on 27 March 2017

Custom keyboard shortcuts in SQL Server Management Studio (SSMS)

People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of time; you’ll definitely notice a boost the productivity because you’re… Read more

0 comments, 291 reads

Posted in PowerSQL By Prashanth Jayaram on 27 March 2017

Orlando Code Camp 2017

I’ll be attending and speaking at Orlando Code Camp  on April 8th. Come by and say hello if you’re attending, maybe we can talk career paths, security, or devops for dbas!


Read more

0 comments, 263 reads

Posted in SQLAndy on 27 March 2017

Reading the January 2017 PASS Minutes

I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a lot was covered. I don’t want to summarize it, you should read it, but there were some trends I noticed I wanted to comment on:

  • Goals are frequently mentioned, but…

Read more

0 comments, 227 reads

Posted in SQLAndy on 27 March 2017

Reviewing the PASS 2017 Budget

I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot of good information. I wish there as more context about some of the changes. The following isn’t a summary, just notes about areas I either care about or caught… Read more

0 comments, 205 reads

Posted in SQLAndy on 27 March 2017

Newer posts

Older posts