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

Archives: April 2018

SQL Server Removing Outliers With Standard Deviation

When running aggregations for reporting in some situations outliers can throw out the numbers.

For example lets say we have a report that shows the quantity of stock lines delivered to the the many warehouses of company X per day. Then lets imagine that a few times a year company… Read more

0 comments, 10 reads

Posted in Gavin Draper's SQL Server 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, 353 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, 101 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, 98 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,835 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,784 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, 278 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, 735 reads

Posted in SQL Server Overview on 30 April 2018

SQL Server Minimum Memory Setting

There is almost never a reason to set this setting unless you’re running other apps on the same server as your SQL Instance and are trying to stop them taking the memory you want the SQL Server to have. It’s always preferable to have your SQL Server be the only… Read more

0 comments, 10 reads

Posted in Gavin Draper's SQL Server Blog on 29 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, 214 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, 242 reads

Posted in SQL Roadie on 29 April 2018

SQL Server Advanced Aggregations Part 2 ROLLUP and CUBE

This post is part 2 of a 3 part series…

  1. Part 1 Grouping Sets
  2. Part 2 ROLLUP and CUBE
  3. Part 3 GROUPING and GROUPING_ID

Following on from my previous post on GROUPING SETS I thought I’d cover a couple of other more advanced aggregation options that are often missed, namely… Read more

0 comments, 9 reads

Posted in Gavin Draper's SQL Server Blog on 28 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, 398 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, 355 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, 577 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, 489 reads

Posted in SQL Server Overview on 27 April 2018

SQL Server Advanced Aggregations Part 1 Grouping Sets

This post is part 1 of a 3 part series…

  1. Part 1 Grouping Sets
  2. Part 2 ROLLUP and CUBE
  3. Part 3 GROUPING and GROUPING_ID

Grouping Sets can be a powerful tool for reporting aggregations. Let’s imagine we have a sales table with a SaleDate and want a count of sales… Read more

0 comments, 10 reads

Posted in Gavin Draper's SQL Server Blog on 26 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, 1,060 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, 411 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, 433 reads

Posted in PowerSQL By Prashanth Jayaram on 26 April 2018

Older posts