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

Latest Blog Posts

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, 74 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, 57 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, 68 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, 97 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, 66 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, 79 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

1 comments, 125 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, 75 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, 70 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, 113 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

Location:

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

0 comments, 58 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

3 comments, 87 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?

DELETE TOP (10)
FROM SalesOrderDetail
ORDER BY SalesOrderID DESC;

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, 83 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, 107 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, 87 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, 85 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, 83 reads

Posted in Matthew McGiffen DBA on 18 September 2018

PASSITON discount code for PASS Summit 2018

This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is in addition to registration going up next by $200 gives $400 off if registered by Friday.

Also, everyone who registers by Friday will be entered into a daily prize draw Read more

0 comments, 66 reads

Posted in The Smiling DBA on 18 September 2018

The Trigger Roundup–T-SQL Tuesday #106

This month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I am glad that there have been quite a few responses.

I started the review almost immediately,and here are a few highlights. I separated these based on how I first thought… Read more

1 comments, 201 reads

Posted in The Voice of the DBA on 18 September 2018

New Whitepaper: Architecting Microsoft SQL Server on VMware vSphere

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Last week VMware has released a new whitepaper with the very promising title “Architecting Microsoft SQL… Read more

0 comments, 120 reads

Posted in Klaus Aschenbrenner on 18 September 2018

Older posts