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

Latest Blog Posts

Hands off dbatools updates

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

One of the downsides of an active project… Read more

0 comments, 118 reads

Posted in The Voice of the DBA on 25 May 2018

DBCC Clonedatabase and Query Store

Cloning things is all the rage these days…..even Storm Troopers.

Anyway, by now, you probably have seen documentation on Query Store and DBCC Clonedatabase.  Query Store, introduced in SQL Server 2016, is considered the “black box” or “flight recorder” of queries.  It retains a history of executed queries, including… Read more

0 comments, 99 reads

Posted in John Morehouse | Sqlrus.com on 25 May 2018

You know everything about GROUP BY. Do you?

SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in everything. I see a lot of people gravitate towards performance; but, that’s not the best place to focus. If you don’t know the fundamentals of the language then you will… Read more

0 comments, 611 reads

Posted in Confessions of a Microsoft Addict on 25 May 2018

Day 25 Optimization

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column locking) for all storage engines except InnoDB, which uses row level locking locking system in MySQL: Implicit Locking: To maintain the … Continue reading

Read more

0 comments, 84 reads

Posted in Vinay Thakur on 25 May 2018

Techorama 2018 Session Materials

Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely organized. Big thanks to the organizers, sponsors and attendees of course.

My session on data modeling in self-service BI went really well (but I had some time left at the… Read more

0 comments, 93 reads

Posted in Koen Verbeeck on 25 May 2018

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed Connection to both servers are accessible. On Master Server: Edit my.cnf with following information: [mysqld] Log-Bin =MySQL_Binlog Server_ID=1 Create … Continue reading

Read more

0 comments, 82 reads

Posted in Vinay Thakur on 24 May 2018

Query Predicates

Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was ranting on and on about how the predicates were written when the person stopped me and asked a very simple question. Like a light bulb going off, it reminded me… Read more

0 comments, 99 reads

Posted in SQLEspresso on 24 May 2018

One Week to Music City Tech

Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in Nashville on May 31-June 2. There are a lot of great sessions on the schedule, covering a lot of software development topics.

I’ll be delivering two talks, one… Read more

0 comments, 481 reads

Posted in The Voice of the DBA on 24 May 2018

Power BI and Data Security – Audit Logs, Powershell, Power BI and @AngryAnalytics

The following has been reposted with permission from Steve Howard a.k.a. @AngryAnalytics. I have made some formatting changes but the content is unchanged. Thanks again to Steve for allowing me to repost this content. You can find the original post and the rest of Steve’s great work on his blog Read more

0 comments, 113 reads

Posted in DataOnWheels on 24 May 2018

Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic

Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair number of different answers.  How do we go about converting a positive number to a negative, or the other way around?

I’ll give you my solution and it uses a… Read more

3 comments, 129 reads

Posted in SQL Undercover on 24 May 2018

Toolbox - How Long Has My Server Been Up?

https://imgflip.com/i/2axp6y
No..not that Up (although it is awesome!)

--

As a remote service provider a common request is to follow up after a server restart (or investigate a possible server restart).  A question that inevitably comes up is "When did the server restart?"

If all you need to know is…

Read more

0 comments, 72 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 May 2018

Tips for Securing SQL Server Database from All Sort of Risks

Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we have discussed about all the concepts and the precautions that can be taken to prevent databases and the accumulated components such…

Read more

0 comments, 507 reads

Posted in SQL Server Overview on 24 May 2018

Thoughts on Query Performance with TDE enabled

Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance  overhead of 2-4%. That doesn’t sound like very much, and personally I wouldn’t let it bother me if I want to make sure my data is encrypted at rest.

However, you may have heard other sources saying that… Read more

1 comments, 469 reads

Posted in Matthew McGiffen DBA on 23 May 2018

Day 23 Replication

Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type of Replication Master-Master Replication Master-Slave Replication Like other RDBMS MySQL works replication on Transactions. The pre requisite of replication is … Continue reading

Read more

0 comments, 89 reads

Posted in Vinay Thakur on 23 May 2018

Jobs in PoSh to Create a Load

I saw this from Argenis Fernandez, and thought it was wonderful.

1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U sa -P ‘iLovePoSh’ -i /home/username/test.sql } }

Create 128 threads, each running a background job in PowerShell to connect to an instance and… Read more

0 comments, 177 reads

Posted in The Voice of the DBA on 23 May 2018

Virtual Log Files: 200 or 1000?

Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During the follow-up meeting, the senior DBA and I had a discussion about Virtual Log Files (VLFs), disagreeing on the maximum number of Virtual Log Files a transaction log should have.… Read more

1 comments, 160 reads

Posted in Born SQL with Randolph West on 23 May 2018

The public role

A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t. Connection only. So how come there are some things that everyone can do once they are connected to a database? Well, it’s the public role. Everyone is a member and… Read more

1 comments, 97 reads

Posted in SQLStudies on 23 May 2018

dbachecks – Save the results to a database for historical reporting

I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got asked was will you write a command to put the results of the checks into a database for historical reporting.

The answer is no and here is the reasoning. The… Read more

0 comments, 480 reads

Posted in SQL DBA With A Beard on 23 May 2018

Deploying Azure Container Instances

In a previous post I went through how to Push an image to the Azure Container Registry

Now let’s look at using that image to create an Azure Container Image instance.

Azure Container Instances (ACI) are Microsoft’s serverless container technology. They allow us to spin up a container without having… Read more

0 comments, 467 reads

Posted in The DBA Who Came In From The Cold on 23 May 2018

How to pass data between procedures using temp tables.

In this post I will show how in some cases we can split a long procedure to a small and manageable parts using a simple technique of passing data in temp tables

Read more

0 comments, 690 reads

Posted in SQL Design Patterns on 23 May 2018

Older posts