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

Archives: June 2018

Be our guest, be our guest, put our database to the test.

When I think of the public role I often think of the guest database principal (user) at the same time. They aren’t really the same though. For one thing while you can’t remove either one, you can disable the guest and in fact for user databases this is recommended.

Best…

Read more

3 comments, 235 reads

Posted in SQLStudies on 25 June 2018

Idera Greek Sync: Performance Tuning with Execution Plans

On Wednesday July 11th, please join Idera Geek Sync at 11AM Central for a walk through some basics in Execution Plans. We will look at the history of execution plans and demonstrate how Microsoft has improved the tools to help DBAs find performance problems. The main body of the presentation… Read more

0 comments, 283 reads

Posted in The Smiling DBA on 24 June 2018

Overview of File-group(s) and Piecemeal database restore operations in SQL Server

So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series, we are going to discuss, the file-group and piecemeal database backup and restore process. Database “Backup and Restore” strategies are … Continue reading

Read more

0 comments, 722 reads

Posted in PowerSQL By Prashanth Jayaram on 22 June 2018

Speaking This Weekend in Iowa City!

Come out to SQL Saturday Iowa at the University of Iowa this Saturday 06/23/2018 for a SQL Saturday that never disappoints - Iowa always puts on a fun event with great atmosphere and informative sessions.

I am giving the premiere of my new presentation "Intro to Powershell for the…

Read more

0 comments, 361 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 June 2018

Transaction Logs and Availability Groups

Everyday I learn something new.  A couple of days ago I posted about a problem I had with Always On and a full transaction log.  Finding root cause came from an article from Pinal Dave stating basically everything we knew what happened.

To recap the problem, transaction log backups… Read more

0 comments, 62 reads

Posted in vitamindba on 21 June 2018

What it is Page Life Expectancy (PLE)

Which cup will you prefer to go the less
number of times to the coffee maker?
image was taken from here
Let us imagine this: Every morning when you get to the office, you must drink coffee to be fully awake, if you are a coffee lover, maybe you should…

Read more

0 comments, 58 reads

Posted in SQL Guatemala on 21 June 2018

New Session: Profiling Your Data

Data Quality is a huge issue, especially now with more and more data being created daily.  According to Micro Focus back in 2016, we were creating 44 ExaBytes of data per day and are expected to produce 463 ExaBytes of data per day by 2025.  That’s a LOT of data. Read more

2 comments, 216 reads

Posted in SQL Swimmer on 20 June 2018

Updating to SQL Change Automation

The SQL Change Automation release was early this week.  This is replacing ReadyRoll and our DLM Automation products, rolling them into a single product and is the first stage of unifying our state and migration based solutions.

When I logged into Visual Studio and checked updates this week, I found… Read more

0 comments, 971 reads

Posted in The Voice of the DBA on 20 June 2018

Dates and Times in SQL Server: DATENAME()

Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME. Where DATEPART returns the date or time part as an integer, DATENAME returns the part as a character string. This DATENAME function also takes two… Read more

0 comments, 852 reads

Posted in Born SQL with Randolph West on 20 June 2018

SSMS reset window layout (Day 37)

SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless what you can do with them. You can even change what columns you see. Invariably, with all of this customization, things go wonky. I’ve even seen windows opened up… Read more

0 comments, 2,523 reads

Posted in A Discussion of SQL Server-Related Topics on 20 June 2018

SQL Server Patching within an Always On Environment

SQL Server Patching with the introduction and adoption of Always On has changed.  The traditional method by waiting for Service Packs is not really the recommended patching cycle anymore.  The cumulative updates are much more important to Always On, so keeping up with the cumulative updates is very important.

It… Read more

0 comments, 93 reads

Posted in vitamindba on 20 June 2018

Overview of SQL Server 2017 Docker containers on Linux machine

SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the freedom that it gives to install the product anywhere. The advent of the Docker containers and growing emphasis on open … Continue reading

Read more

2 comments, 1,365 reads

Posted in PowerSQL By Prashanth Jayaram on 20 June 2018

Strings vs Identifiers

A common mistake, and one I make frequently myself is to use a string in place of an identifier, or vise-versa. So to start, let’s have some definitions, shall we?

String

a linear sequence of characters, words, or other data.

Identifier

a sequence of characters used to identify or refer…

Read more

3 comments, 3,306 reads

Posted in SQLStudies on 20 June 2018

Replication Max Text Length

Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce it to those that had not.

Error Description: Length of LOB data (65754) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum… Read more

2 comments, 2,076 reads

Posted in SQLEspresso on 20 June 2018

Deploying to Azure Without Writing JSON Arm Templates

Reading Time: 6 minutes (not a minute longer) TLDR; ARM templates are a great way to deploy to Azure, setting up a template that can deploy an entire environment from databases to web servers and load balancers to firewalls (damn you azure, ok, I’ll call it an nsg) is satisfying…

Read more

0 comments, 359 reads

Posted in Ed Elliott's Sql Developer Blog on 19 June 2018

Deploying to Azure Without Writing JSON Arm Templates

Reading Time: 6 minutes (not a minute longer) TLDR; ARM templates are a great way to deploy to Azure, setting up a template that can deploy an entire environment from databases to web servers and load balancers to firewalls (damn you azure, ok, I’ll call it an nsg) is satisfying…

Read more

0 comments, 261 reads

Posted in Ed Elliott's Sql Developer Blog on 19 June 2018

SQL Saturday Houston is this weekend

I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the Houston, TX area be sure to head over to the SQL Saturday website to register. You can find more details here:  http://www.sqlsaturday.com/766/eventhome.aspx 

There are over 50 sessions across… Read more

0 comments, 269 reads

Posted in Confessions of a Microsoft Addict on 19 June 2018

Removing a secondary replica database in Always On SQL Environment

Removing a database from an Always On availability group is pretty straight forward and can be accomplished by either ssms or script.

To remove a database from a secondary replica after it is removed from the primary replica may result in errors if you are using the ssms.  The script… Read more

0 comments, 89 reads

Posted in vitamindba on 19 June 2018

Verify Allocation Unit Size for SQL Server

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit size.  Processes such as the checkpoint and Lazy Writer try to write in extents when possible.  Extents are a collection of 8… Read more

10 comments, 446 reads

Posted in Ryan Adams on 19 June 2018

Verify Allocation Unit Size for SQL Server

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit size.  Processes such as the checkpoint and Lazy Writer try to write in extents when possible.  Extents are a collection of 8… Read more

0 comments, 46 reads

Posted in Ryan Adams on 19 June 2018

Newer posts

Older posts