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

Latest Blog Posts

Availability Groups: When Your Synchronous Secondary isn’t Synchronous

During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit behave.

How An Availability Group With A Synchronous Secondary Should Behave Under Normal Circumstances

Normally, if we’ve got a secondary replica in synchronous commit mode, our primary can’t commit any… Read more

1 comments, 131 reads

Posted in SQL Undercover on 14 January 2019

DevOps and Automation Will Eliminate the DBA

I’ve been reading about the death of the DBA ever since I first made the jump from full time developer to full time data professional. The first time I heard it was when SQL Server 7.0 was released. Did you know that SQL Server 7.0 was self-tuning? In fact, it… Read more

0 comments, 219 reads

Posted in The Scary DBA on 14 January 2019

Developing Presence

At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to the Women in Technology presentation at lunch. Part of the discussion was around how height can influence being noticed. I agree that it does play a huge role. At 5’7″,… Read more

0 comments, 88 reads

Posted in Databases – Infrastructure – Security on 14 January 2019

SQL Server Monitoring: What to start measuring

So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare minimum, you want to collect wait statistics. Let’s talk about a basic wait statistics collection.

Our new best friend: dm_os_wait_stats

This is the only place we need to query. It’s… Read more

0 comments, 116 reads

Posted in Arthur's Blog on 14 January 2019

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what.  In addition, they may need to know by what means people have access within your databases.

When that need arises, it is frequently adequate to… Read more

0 comments, 124 reads

Posted in SQL RNNR on 14 January 2019

SQL Bits 2019: The Great Data Heist

SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL conferences out there and you still have time to make it! (Although not much, that’s only about a month and a half).

As much as I love PASS and PASS… Read more

0 comments, 101 reads

Posted in SQLStudies on 14 January 2019

Data Warehousing Tip #4 – Trust your instinct

My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you the solution seems too complex then maybe it is.

Sometimes things are just complex.  It’s the way that it is.  However, sometimes things are more complex than they need to… Read more

0 comments, 187 reads

Posted in Chris Jenkins' Blog on 14 January 2019

Dodging Deadlocks With Indexes

A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index. The most commonly talked about deadlock solutions that I see are …

  • Switch the order locks are taken out in your queries (If it’s possible or makes sense)
  • Reduce the…

Read more

0 comments, 116 reads

Posted in Gavin Draper's SQL Server Blog on 14 January 2019

Last Week Reading (2019-01-13)

Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The last episode. Personally, I’m sad, but waiting for new ideas from Brent (T). Easily embed secure Power BI reports in your internal portals or websites Embed securely in internal applications… Read more

0 comments, 123 reads

Posted in SQL Player Blog on 13 January 2019

MongoDB Replica-Set

The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can easily setup it here is the link for it which I am used by Soham Kamani Create a network: Docker … Continue reading

Read more

0 comments, 119 reads

Posted in Vinay Thakur on 13 January 2019

New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

My new course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right in check it out here!…

Read more

0 comments, 129 reads

Posted in Anthony Nocentino's Blog on 12 January 2019

MongoDB – Storage

MongoDB has a Storage Wired Tiger by default MongoDB generated some standard wt (WiredTiger extension) files, WiredTiger uses MultiVersion Concurrency Control (MVCC)  and can provide point time recovery using Journal (write ahead log-checkpoint) and ACID property – Concurrency. MongoDB stores the … Continue reading

Read more

0 comments, 120 reads

Posted in Vinay Thakur on 12 January 2019

The Necessary Extras That Aren’t Shown in Your Azure BI Architecture Diagram

When we talk about Azure architectures for data warehousing or analytics, we usually show a diagram that looks like the below.

Modern DW Architecture https://azure.microsoft.com/en-us/solutions/architecture/modern-data-warehouse/

This diagram is a great start to explain what services will be used in Azure to build out a solution or platform. But many times,… Read more

5 comments, 346 reads

Posted in Data Savvy on 11 January 2019

Execution plans: RetrievedFromCache

I first came across the value for RetrievedFromCache when I was reading a confusing execution plan. At first, I thought this could be really useful. If this value was true, you could assume that another query had compiled the execution plan that your query used and your query had retrieved… Read more

0 comments, 56 reads

Posted in Arthur's Blog on 11 January 2019

Book Review: SQL Server 2017 on Linux

I don’t have any statistics but I think most IT Professionals in the SQL Server field are managing or developing solutions on their SQL Server Databases deployed on Windows Servers. If you’re planning to try SQL Server on Linux, this is a good book to get you started. Or, if… Read more

0 comments, 347 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 11 January 2019

Introducing ChaosLoad

Scripted Simulation of SQL Server Loads

When blogging, presenting or testing an idea, one issue I constantly have is that my local SQL Server used for all these things has no real load on it making it hard to test how things I do work concurrently or under stress. I… Read more

0 comments, 1,031 reads

Posted in Gavin Draper's SQL Server Blog on 11 January 2019

ASF 018 video invitation

What popular tool has he created in 2006?

What popular tool has he created in 2006? How many people do live in our guest’s country? What can give you a valuable perspective? New podcast episode is coming (next Friday) and in the meantime, you can watch that episode’s trailer. Simply… Read more

0 comments, 107 reads

Posted in SQL Player Blog on 11 January 2019

Big Changes for WaterOx Consulting

March of 2019 would have marked that start of the 8th year of WaterOx Consulting, Inc. running. That isn’t going to happen. I have been thinking hard for the last year about what to do when it comes to the consulting/incorporated side of my SQL life and have come to… Read more

0 comments, 133 reads

Posted in WaterOx SQL on 10 January 2019

Sorting Values in a Column

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

This was a post that caught my eye, since I’d just written a piece on STRING_SPLIT(). Someone had this data:

DECLARE @Names VARCHAR(8000) = 'Steve, Grant, Kathi,…

Read more

0 comments, 181 reads

Posted in The Voice of the DBA on 10 January 2019

Power BI World Tour 2019 Tampa

In just a few weeks (Jan 21-22) I will be presenting on two topics at the Power BI World Tour in Tampa. There’s a great line up of speakers including those on Microsoft product team, MVPs, User Group leaders and industry experts. I’ll be speaking on the following topics:

Read more

0 comments, 171 reads

Posted in Devin Knight on 10 January 2019

Newer posts

Older posts