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

Latest Blog Posts

Power BI Data Security – Sharing in Email


Microsoft has expanded sharing by allowing users to share Power BI content via email. In a previous post, I discussed how sharing content within your organization should be handled carefully. However, the new process opens up the opportunity to share outside your organization by sending an email.… Read more

0 comments, 57 reads

Posted in DataOnWheels on 22 March 2018

I learned about the order of logical operations #SQLNewBlogger

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

I had logic in a CS curriculum many years ago and I’ve worked with AND and OR statements for years. I’ve sometimes confused myself, but I usually ensure… Read more

2 comments, 66 reads

Posted in The Voice of the DBA on 22 March 2018

SQL Vulnerability Assessment for Azure SQL Database

Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA). It is currently in preview mode where it has the ability to find, you can guess, security based vulnerabilities for your database such as misconfigurations, excessive permissions, and exposed sensitive… Read more

0 comments, 59 reads

Posted in All About SQL on 22 March 2018

Stop Previewing the bim.layout File in SSAS Tabular

A quick blog post for future reference, because I know I’ll bump into this again someday.

When you’re working with a team on a Analysis Services Tabular project, you most likely will check your code into some sort of source control (yes, you do. If not, start tomorrow). One of… Read more

0 comments, 58 reads

Posted in Koen Verbeeck on 22 March 2018

Recruitment Agents are not bad people...despite what you might read

Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships. My name is Gethyn Ellis I have been running a SQL Server consulting and training practice for the last ten years. You can check out my website and blog…

Read more

0 comments, 70 reads

Posted in The SQL DBA in the UK on 22 March 2018

Webinar: Identify and Eliminate SQL Server Performance Issues

I’m giving a webinar tomorrow, March 22, 2018, at 3 PM Eastern.

Free Registration Link

Here’s what I’ll be covering:

Are you struggling with pesky SQL Server performance issues that are impacting your business? Are you not sure where to turn next to focus your efforts to resolve the issue? Read more

0 comments, 89 reads

Posted in Databases – Infrastructure – Security on 21 March 2018

Dates and Times in SQL Server: DATETIME2

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the DATETIME and SMALLDATETIME types that we looked at previously. This week, we look at the DATETIME2 data… Read more

0 comments, 102 reads

Posted in Born SQL with Randolph West on 21 March 2018

Working with tabs and spaces in SSMS (Day 34)

There are several different options available for working with tabs and spaces in SSMS. In fact, there are enough that I could make several tips out of them. I decided to just keep all the tips together.

Tabs and Spaces options

The first thing that I want to go over… Read more

1 comments, 82 reads

Posted in A Discussion of SQL Server-Related Topics on 21 March 2018

TempDB Filling Up On Secondary Replicas

Have you ever had an issue where TempDB was filling up on your secondary replicas?  Do those secondaries happen to be read only replicas?

When I have an issue with tempdb filling up the first thing that I usually do is try to figure out exactly what the space has… Read more

0 comments, 94 reads

Posted in SQL Undercover on 21 March 2018

SQL Server Data Management Life Cycle

This is the second article in the “Backup and Restore (or Recovery) in SQL Server” stairway series (see the full TOC below). This article deals with the different phases of data management life cycle and it encompasses the following topics:

  1. Introduction to data corruption
  2. Defining data corruption and its causes

Read more

0 comments, 95 reads

Posted in PowerSQL By Prashanth Jayaram on 21 March 2018

Moving a table using BCP and native format

You need to move a table from one instance to another with the following requirements:

  • The instances are on separate domains. In fact, you might be shipping the table to a vendor or client.
  • The destination is an actual SQL Server instance.
  • Can be automated on either end.
  • Quick and…

Read more

1 comments, 96 reads

Posted in SQLStudies on 21 March 2018

Redgate SQL Test utility isn’t showing up in SSMS

I had recently installed the SQL Toolbelt from Redgate at a client site on a laptop they’d supplied me.

(Fantastic product that SQL Toolbelt BTW.)

Things were going swimmingly – in fact thanks to SQL Compare, SQL Source Control and Team Foundation Server I had implemented an automated Continuous Delivery… Read more

0 comments, 96 reads

Posted in The Hybrid DBA's Blog on 21 March 2018

SQL Performance – Using Query Hint OPTION (FAST N)

It is fun working with SQL/Application developer where you exchange a lot of technical thoughts to find the root of the issues. Recently, one of the developers optimized the OLTP system stored procedure by putting the query hint OPTION (FAST ‘N’). But, he was not sure enough about… Read more

0 comments, 134 reads

Posted in SQL Geek on 21 March 2018

Identify R Package Dependencies Using miniCRAN

Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited to installing one package at a time. If you have an R Package with dependencies, you have to install those in a separately.

Here’s an easy way to… Read more

0 comments, 95 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 20 March 2018

Experiment with SQL Server and DBFS on Linux

Given that Microsoft now considers Linux a ‘first-class citizen’, SQL Server 2017 offers native support for Linux. It is engineered to be cross-platform, and that’s good news for Linux administrators and open source developers. Microsoft’s support for Linux (and open source in general), has come into clearer focus, and the… Read more

0 comments, 96 reads

Posted in PowerSQL By Prashanth Jayaram on 20 March 2018

How To Steal Data Using Second Order SQL Injection Attacks

One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter directly into your dynamically built query string:

While this type of injection flaw is easy to spot, there are other less direct ways an injection attack can occur.

Second Order…

Read more

0 comments, 162 reads

Posted in Bert Wagner on 20 March 2018

An Introduction to Enterprise Architecture

An Introduction to Enterprise Architecture

In this series I’m going to be looking at enterprise architecture. Over the last few years many of the projects that I have been involved with have involved complex digital transformation for large organisations. Delivering change in a large organisation can be a complicated and…

Read more

0 comments, 132 reads

Posted in The SQL DBA in the UK on 20 March 2018

“The report server Web Portal URLs and Web Service URLs don’t match”

A client recently upgraded a server, and then started receiving this error when they tried to access the SSRS Reports page at http://MyServerName\Reports: The service is not available. The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server Web Portal URLs… Read more

0 comments, 104 reads

Posted in SQL Awesomesauce on 19 March 2018

SQL Saturday Iceland–What an Adventure!

Two Saturdays ago, I was in Reykjavik, Iceland, speaking at my very first international SQL Saturday.  WOW!  Is all I can say.  While this SQL Saturday is one of the smaller events I’ve spoken at, it definitely made an impression and will most likely go down as one of my… Read more

0 comments, 118 reads

Posted in SQL Swimmer on 19 March 2018

Query Monitoring and the GDPR

I’ve been reading the General Data Protection Regulation (GDPR) and discussing the ramifications of the beginning of enforcement with lots of people. The implications of it all are fascinating. The real serious issues remain primarily a business problem, with business defined solutions. However, there are technology issues that we need… Read more

0 comments, 108 reads

Posted in The Scary DBA on 19 March 2018

Older posts