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

Archives: April 2018

Guide for Setting up Telegraf to Monitor InfluxDB

Problem

If you been reading this series you are used to looking at Windows and SQL Server but who knows what InfluxDB is and what to look at there especially if installed it on Linux.  Lucky for us there is a dashboard to use to watch InfluxDB as well so… Read more

0 comments, 173 reads

Posted in Database Superhero’s Blog on 30 April 2018

Automating Automatic Indexing in Azure SQL Database

I’ve been in love with the concept of a database as a service ever since I first laid eyes on Azure SQL Database. It just makes sense to me. Take away the mechanics of server management and database management. Focus on the guts of your database. Backups, consistency checks, these… Read more

5 comments, 1,612 reads

Posted in The Scary DBA on 30 April 2018

SQL and Azure Maze

Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found them on http://www.printactivities.com/ which has a bunch of great resources for teachers (and bloggers looking for something fun/relaxing for their readers). Click on the images for larger versions of the… Read more

0 comments, 1,620 reads

Posted in SQLStudies on 30 April 2018

Shiny Tech Syndrome

This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing since sliced bread and consequently wants to shoehorn it in to everything.

(think that person who just started learning NoSql)

I’m not singling anyone out here as we are all… Read more

1 comments, 154 reads

Posted in The DBA Who Came In From The Cold on 30 April 2018

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, 173 reads

Posted in SQL Server Overview on 30 April 2018

What is Azure Cosmos DB?

 

What is Azure Cosmos DB and why should you get excited about it?

Cosmos DB started as an internal project – “Project Florence” – at Microsoft in 2010. It is a globally distributed, highly scalable and performant multi-model database service built on Azure. It was built ground… Read more

0 comments, 34 reads

Posted in SQL Roadie on 29 April 2018

Export data from Cosmos DB to SQL Server

Cosmos DB is Microsoft’s latest NoSQL database offering low latency, high scalability and geo-distribution to any Azure region. Read more about Cosmos DB here. In its infancy, Cosmos DB was known as Document DB. Renaming was inevitable as Document DB evolved beyond just a document store.

Following is a… Read more

1 comments, 42 reads

Posted in SQL Roadie on 29 April 2018

YouTube Channel Update: 27 April 2018

Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos (so sorry about that), I am still posting videos. Please subscribe to the channel.

Video Lists

I created video lists. Here they are, in no particular order:

SQL Server and… Read more

0 comments, 204 reads

Posted in The Scary DBA on 27 April 2018

Working with Consultants

After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several different areas of world, although most of them are based here in the United States.  Over that time I learned every client is different and handles things differently, but that… Read more

0 comments, 195 reads

Posted in John Morehouse | Sqlrus.com on 27 April 2018

How to get alerted anytime SQL Service is restarted?


You may and should have monitoring in place to monitor state of your servers, services, jobs, critical and not critical errors etc.

Here I just wanted to share a quick script to create a SQL Server agent job to alert you whenever SQL Server service is started/restarted.

If you have…

Read more

0 comments, 322 reads

Posted in Mission: SQL Homeostasis on 27 April 2018

Top 5 Features of SysTools SQL LDF Recovery Software - Review

An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for viewing transaction log file of SQL Server 2016, 2014, 2012, 2008 R2 database, and 2005. It is so because I personally had used this application for resolving many problems… Read more

0 comments, 240 reads

Posted in SQL Server Overview on 27 April 2018

SQL Ops Studio extension development : Starting an adventure

I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took me to Oracle and then translated nicely to SQL Server where I’ve spent the bulk of my time.

Along the way different projects had different requirements and challenges. To take… Read more

0 comments, 793 reads

Posted in Confessions of a Microsoft Addict on 26 April 2018

180 – Is It Time For A Turnaround?

What needs to change? The challenge to explore is are there things in your current day to day that needs to change? Maybe there are some habits, things, processes that need to be turned around. One of the most difficult things about turning around in my mind is acknowledging the… Read more

0 comments, 175 reads

Posted in The SQL Professor on 26 April 2018

SQL Server database Backup and Restore strategies

One of the most important roles of a database administrator is to constantly protect the integrity of the databases and maintain the ability to recover quickly in case of a failure. In light of this, it’s critically important to have a backup-and-recovery strategy in place in order to be ready… Read more

0 comments, 226 reads

Posted in PowerSQL By Prashanth Jayaram on 26 April 2018

Embeded PowerBI

2 comments, 238 reads

Posted in The Smiling DBA on 26 April 2018

How to find out whether your database is transactional, analytical or hybrid?


If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what type of application load is being handled by your SQL Servers.  In some cases you don't even need to know to do your job.

But if you are a performance…

Read more

0 comments, 213 reads

Posted in Mission: SQL Homeostasis on 26 April 2018

dbachecks – Going parallel – Cut off your execution times

On one of the last clients I have worked, I have implemented dbachecks in order to get the state of art and know how cool or bad the environments are before start knocking down the bad practices. This client has seven different environments with more than 100 instances and more… Read more

5 comments, 208 reads

Posted in Cláudio Silva on 26 April 2018

Gather Always On Configuration using a DMV query


If you were like me, you would know your AG configuration by heart. However, what if you get busy with increasing responsibilities in other areas, projects etc.? Therefore, you do not just want to rely on your memory. On the other hand, maybe you want to simply collect snapshot of…

Read more

0 comments, 169 reads

Posted in Mission: SQL Homeostasis on 26 April 2018

Check health and status of Availability Group using DMVs






-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorum
SELECT * FROM sys.dm_hadr_cluster
SELECT * FROM sys.dm_hadr_cluster_members


-- Health of the AGs
SELECT ag.name agname, ags.* FROM sys.dm_hadr_availability_group_states ags INNER JOIN sys

Read more

0 comments, 199 reads

Posted in Mission: SQL Homeostasis on 26 April 2018

Securing Test and Dev Environments at the SQL Privacy Summit

Redgate Software is putting on a one day SQL Privacy  Summit on May 18 in London at the Grange Tower Bridge. This is a chance to see how you can ensure compliance with the GDPR while keeping up the modern pace of DevOps software development. Our goal is to… Read more

0 comments, 253 reads

Posted in The Voice of the DBA on 26 April 2018

Older posts