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

Posted in Database Superhero’s Blog on 30 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, 56 reads

Posted in Database Superhero’s Blog on 30 April 2018

Security: Create and view Audit Logs

It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this can be difficult to achieve on large environments, where a lot of people have elevated privileges or several people have permissions to perform tasks over your data or schema.

As…

Read more

0 comments, 52 reads

Posted in SQL Guatemala 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,781 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,734 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, 231 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, 603 reads

Posted in SQL Server Overview on 30 April 2018

Introduction to Azure Cosmos DB

What is Azure Cosmos DB?

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 up with horizontal scalability and global distribution in view,… Read more

3 comments, 137 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 Microsoft documentation about Cosmos DB here or check out my blog about Introduction to Azure Cosmos DB. In its infancy, Cosmos DB was known as Document DB. Renaming was inevitable… Read more

1 comments, 163 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, 356 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, 306 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, 519 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, 407 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, 969 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, 349 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, 382 reads

Posted in PowerSQL By Prashanth Jayaram on 26 April 2018

Embeded PowerBI

0 comments, 326 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, 291 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, 335 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, 258 reads

Posted in Mission: SQL Homeostasis on 26 April 2018

Older posts