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

Archives: September 2018

Azure Integration with Flow

Today I’m talking more about integration with Flow within Azure. Flow is focused around business power users who need to create workflows or other things that move the data within and around applications. One benefit is that it eliminates the need for having IT staff build these workflows.

Flow… Read more

0 comments, 76 reads

Posted in DataOnWheels on 21 September 2018

[Video] Configuring Geo-Replication to SQL DB

With the hurricane bearing down on the east coast of the United States last week, making sure you have a good disaster recovery plan in place should have been a top priority for you.  If you happen to be using Azure SQL DB, adding geo-replication is a simple and easy… Read more

1 comments, 56 reads

Posted in John Morehouse | Sqlrus.com on 21 September 2018

Best Trick to Extract Data From SQL Server MDF File Instantly

SQL Server is a relational database management system in technology field it supports more than one transaction processing. MDF is utilized to save information like views, stored information and so on and secondary is .ldf file, that stores transactional information of its related primary database file MDF. Moreover, .mdf is… Read more

0 comments, 114 reads

Posted in SQL Server Overview on 21 September 2018

Moving Objects to a New Schema

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

I haven’t had the need to move an object from one schema to another in years. Really since SQL Server 2000. I wrote about deleting a user that… Read more

0 comments, 148 reads

Posted in The Voice of the DBA on 20 September 2018

Azure Integration Options and Overview

Today I’d like to talk about Azure integration services that you can leverage within the platform. Integration services allow data to interact with other applications or businesses and to move data around within the platform. I’d like to discuss what is currently available, where it might fit, as well as… Read more

0 comments, 99 reads

Posted in DataOnWheels on 20 September 2018

Rescheduled Performance Troubleshooting Webinar

With Hurricane Florence no longer a hurricane, we have rescheduled the webinar for next Wednesday, September 26, 2018.

Free sign up for the webinar!

Here is what I’ll be covering:

How do go about finding poorly performing SQL Server queries in your environment? And once you find them, what can… Read more

0 comments, 84 reads

Posted in Databases – Infrastructure – Security on 19 September 2018

Why Customers Are Looking At Azure

As a Principal Consultant with Pragmatic Works, I have many conversations with customers about moving to Azure. As a Consulting Sales Manager, Jon Reutinger, has these discussions every day. I sat with Jon to ask what he commonly hears from customers about why they are looking at Azure.

People want… Read more

0 comments, 117 reads

Posted in DataOnWheels on 19 September 2018

Apply for the 2019 Idera ACE Program

Sharing this before I forget, Idera is taking applications for their 2019 ACE Program. If you’re wanting to do more in the community, this is an interesting opportunity.

Read more

0 comments, 88 reads

Posted in SQLAndy on 19 September 2018

Public Service Announcement: check your backup notifications

The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected many customers — including Microsoft’s own services — for almost an entire day. Given that the cloud is ostensibly designed to mitigate downtime by way of distributing workloads across multiple… Read more

0 comments, 96 reads

Posted in Born SQL with Randolph West on 19 September 2018

What is Projectsv13 in SQL Change Automation?

I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting up a new PoC (Proof of Concept), they were confused about why there is a new entry in their list of SQL Servers.

If you’re wondering, this is what you… Read more

2 comments, 186 reads

Posted in The Voice of the DBA on 19 September 2018

All about PASS Summit 2018

Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this blog, of course. Register for Denny Cherry’s attendee orientation. Sign up for the PASS Buddy Program. And their advice about travel. Get on Twitter and meet people. Check out the… Read more

0 comments, 91 reads

Posted in SQL Awesomesauce on 19 September 2018

Three skills to look for in a technology partner

SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you to set up SQL Treeo? When I talked to key decision makers – CEOs, finance directors and IT managers – about monitoring and optimising their SQL Servers, I kept hearing… Read more

0 comments, 84 reads

Posted in SQL Treeo on 19 September 2018

Overview of SQL Joins in SQL Server

The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is accomplished with the SQL join clause.  It’s the nature of traditional relational database systems where some table … Continue reading

Read more

0 comments, 132 reads

Posted in PowerSQL By Prashanth Jayaram on 19 September 2018

Midlands PASS Reboot!

If you’re in or near the Columbia, SC area, we are rebooting the Midlands PASS Chapter. Here is our first meeting information.

Oct 2, 2018

5:30 PM – Meet & Greet
6-8 PM – Technical Presentation by K. Brian Kelley


440 Knox Abbott Drive Suite 425
Columbia/Cayce, SC… Read more

0 comments, 75 reads

Posted in Databases – Infrastructure – Security on 19 September 2018

Databases and DevOps, It’s Not Just Me

Anyone who subscribes to my blog or my YouTube channel as well as anyone following me on social media knows that I talk about DevOps and databases a lot. I can’t help it. I have a real passion for the topic. I sincerely believe we should all be taking advantage… Read more

5 comments, 112 reads

Posted in The Scary DBA on 19 September 2018

You can’t DELETE TOP (x) with an ORDER BY

Did you know you can’t do this?

FROM SalesOrderDetail

Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword ‘ORDER’.

I didn’t. Until I tried it anyway. Turns out, it says so right in the limitations section of BOL.… Read more

5 comments, 100 reads

Posted in SQLStudies on 19 September 2018

Careful with your SQL Server Max Memory settings

Quite often I see database administrators set SQL Server max server memory thinking everything related to SQL Server uses this shared memory pool. This is a mistake. There are many things that rely on memory that are not part of SQL Server. Best practices state that you should leave memory… Read more

2 comments, 135 reads

Posted in SQLEspresso on 19 September 2018

Powershell Error – Import-Module AzureRm

I was playing with SQL Azure on my brand new Surface pro device.  I open the Windows Powershell ISE as administrator to import AzureRm module by running the below command;

Import-Module AzureRm

It returned this error:

PS C:\windows\system32> C:\Users\User\Desktop\Azure Script.ps1
File C:\Users\User\Desktop\Azure Script.ps1 cannot be loaded because running scripts is…

Read more

0 comments, 103 reads

Posted in SQL Geek on 19 September 2018

ExpressRoute and VPNs in Azure

In this edition of Azure Every Day, I’d like to discuss networking and interacting between your data center and Azure. Two options you have are ExpressRoute and VPNs and I’d like to point out some reasons why you may choose one option over another or use a combination of both. Read more

0 comments, 101 reads

Posted in DataOnWheels on 18 September 2018

Don’t Just Rely on Query Execution Stats for T-SQL Execution

I recently had an incident where I was looking into the cause of a long running process for a client. It was a batch process that ran overnight, and execution time had been growing until it was now taking over 4 hours.

The database involved is a kind of staging… Read more

0 comments, 104 reads

Posted in Matthew McGiffen DBA on 18 September 2018

Older posts