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

Archives: December 2018

Using Microsoft Learn

I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows Development. There seem to be quite a few classes for each category and at that this is still fairly new and I expect it will grow over time. Everything… Read more

3 comments, 372 reads

Posted in SQLStudies on 31 December 2018

Happy New Year, Here are our Most Popular Posts of 2018

Firstly, all of us at SQL Undercover would like to wish you a very Happy New Year and all the best for 2019.

To sign off for the year, here’s a quick run down of the most popular posts from SQL Undercover in 2018.

Thanks to everyone who’s supported us… Read more

0 comments, 178 reads

Posted in SQL Undercover on 31 December 2018

Finding Installed Event Sessions

As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying to figure things out for yourself. It may even be very common to feel the icy pain of the development cold shoulder (intentional or not) as you go about doing… Read more

1 comments, 171 reads

Posted in SQL RNNR on 31 December 2018

Using WGS 84 shape maps in Power BI

(2018-Dec-31) Back in July of 2018, Ontario provincial government of Canada decided to decrease the number of Toronto city wards from 47 to 25. That was affirmed by conducting the municipal election a few months later in October of 2018 to select councils for those newly shaped 25 wards.

This whole…

Read more

2 comments, 482 reads

Posted in Data Adventures on 31 December 2018

A Better Way to Clean Up the SSIS Catalog Database

Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables. This nightly process removes data for operations that are older than 365 days. While this is useful, many SSIS admins have complained that this process is very slow and contentious… Read more

6 comments, 198 reads

Posted in Tim Mitchell on 30 December 2018

…and where’s the second half gone?

I mean, it can’t be that my calendar shows December and the year is almost over? Alright, I see I definitely have to work on my time management. For now, let me complete the reports of events I have spoken at, and for next year I will try to find… Read more

0 comments, 135 reads

Posted in DerFredo blogs on 30 December 2018

SQLs Black Box Recorder – sp_server_diagnostics

Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore,… Read more

1 comments, 252 reads

Posted in SQL RNNR on 30 December 2018

SQL Servers Black Box Recorder – system_health

Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore,… Read more

1 comments, 287 reads

Posted in SQL RNNR on 29 December 2018

Adding a database running in a docker container to SQLTest

in my previous post I wrote about how easy it is to add the tSQLt unit test framework to your database if it is running in a docker container.

How to use tSQLt unit test framework with a SQL Server database in a docker container

But let’s say you have… Read more

0 comments, 208 reads

Posted in The Hybrid DBA's Blog on 29 December 2018

How to use tSQLt unit test framework with a SQL Server database in a docker container

This blog post describes how to add the tSQLt unit testing framework to a database running in a docker container. You may have already read my article on how easy it is to install against a ‘normal’ SQL Server instance – running on windows…

How to install the tSQLt unit… Read more

1 comments, 1,134 reads

Posted in The Hybrid DBA's Blog on 29 December 2018

How to install the tSQLt unit test framework to start unit testing your database code

This blog post describes how easy it is to install the tSQLt framework.

Don’t know much about tSQLt? If you are serious about dealing with data in SQL Server then you should be as serious about unit testing the changes you are making to your stored procedures, functions and the… Read more

1 comments, 224 reads

Posted in The Hybrid DBA's Blog on 29 December 2018

How to Cluster MaxDB on Windows in the Cloud #Azure #AWS #GCP #SAP

Recently I have had a number of customers looking for a high availability solution for MaxDB on Windows in the cloud. Some customers have been in Azure and some in AWS. But regardless of the cloud platform, they all eventually find the post in the SAP Community WIKI that describes… Read more

0 comments, 22 reads

Posted in Clustering for Mere Mortals on 28 December 2018

Shrinking Tempdb in SQL Server won’t work?

Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly larger and I didn’t have much space on the drive of that server. I tried shrinking the mdf file of … Continue reading

Read more

0 comments, 929 reads

Posted in PowerSQL By Prashanth Jayaram on 28 December 2018

Webcast: Data Modeling Scenarios and Best Practices

On January 17, 2019, I will be giving a webcast with MSSQLTips on data modeling best practices. It’s scheduled for 3 PM EST (8 PM UTC). Here’s the link to register:

Register for Data Modeling Scenarios and Best Practices (free)

Here’s what I’ll be talking about:

In this session we’ll… Read more

0 comments, 1,257 reads

Posted in Databases – Infrastructure – Security on 28 December 2018

Testing SQL in the Advent of Code

I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in the way. Still, trying to solve some programming challenges is a good way of practicing your skills. If you’re competitive, you can try and see how quickly you can solve… Read more

0 comments, 2,076 reads

Posted in The Voice of the DBA on 28 December 2018

Azure – Creating a storage account

Azure offers a lot of features that enable IT professionals to really enhance their environment.  One feature that I really like about Azure is storage accounts.  Since disk is relatively cheap, this continues to hold true in the cloud.  For less than $100 per month, you could get up to… Read more

2 comments, 2,420 reads

Posted in John Morehouse | Sqlrus.com on 28 December 2018

SQL Servers Black Box Recorder – Def Trace

Across many professions and industries there is often a need to have some sort of device that “audits” everything that happens with a device or process. We are probably all quite familiar with the infamous black box recorders used by the passenger airline and train industries. It is also quite… Read more

1 comments, 227 reads

Posted in SQL RNNR on 28 December 2018

Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC)

(last updated: 2019-01-08 @ 13:53 EST / 2019-01-08 @ 18:53 UTC )

There are times when I am working on a SQL script that really shouldn’t be executed all at once. Sometimes it’s a series of examples / demos for a presentation or forum answer. Other times it’s just a… Read more

1 comments, 3,093 reads

Posted in SQL Quantum Leap on 28 December 2018

Data Warehousing Tip #2 – What your data warehouse should be

I’ve seen data warehouses that nobody trusts, or are just too complex for end users to report on.  Users will voice their concerns (usually quite loudly).  Even worse, they will go back to using the relational source to get “accurate” data or because “it’s easier” to get data from there.… Read more

0 comments, 1,224 reads

Posted in Chris Jenkins' Blog on 28 December 2018

Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell

I was asked by the reader on how to get all the port information of SQL Servers instances. As you all know that PowerShell is built on .Net automation framework. I would prefer PowerShell to design any such requirements than … Continue reading

Read more

0 comments, 382 reads

Posted in PowerSQL By Prashanth Jayaram on 27 December 2018

Older posts