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

Archives: December 2018

Global AI Bootcamp – Developing AI, responsibly

Global AI Bootcamp, Brisbane 2018

Yesterday, I attended the Global AI Bootcamp Brisbane (at the Precinct, Valley) along with nearly 100 other technology enthusiasts. The event was well organized by David Alzamendi of Wardy IT Solutions and Thiago Passos of SSW Consulting. I rocked up to the event hoping to… Read more

0 comments, 202 reads

Posted in SQL Roadie on 16 December 2018

Using the SSIS Multiple Flat Files Connection Manager

When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data spread across multiple files. For example, if you are ingesting files generated on a periodic basis (per day, per hour, etc.), you could have dozens or hundreds of files with… Read more

1 comments, 110 reads

Posted in Tim Mitchell on 15 December 2018

Test connection failed because of an error in initializing provider. Oracle client and networking components were not found

You may experience the following error. When a developer installed oracle client and tested the visual studio BIDS packages ask you to fix this. We know the MS only has a visual studio BIDS 32 bit.

Recently, It asked in the forum, I had managed Oracle sometimes and had same… Read more

0 comments, 64 reads

Posted in SQL Server Blog Forum on 15 December 2018

Extract the File Name in SSIS Data Flows using the FileNameColumnName Property

When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for auditing purposes, or you include it directly in the output table, the odds are good that you’ll want to have that… Read more

2 comments, 104 reads

Posted in Tim Mitchell on 15 December 2018

Azure Backup Storage Options

As a database administrator, I am very conscious of how data is being backed up.  Up until SQL Server 2012, you were limited to backing up your databases to a physical device.  That device could be a tape, local disk, or network storage.  After successfully creating a backup, if you’re… Read more

2 comments, 144 reads

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

The Year in Review Webinar–Dec 18

Join me for our Year in Review Webinar next week, Dec 18, at 4pm GMT. I’ll be joining Kendra and Grant to talk through what happened this year, and make a few predictions for 2019.

It should be fun, festive, maybe a bit silly, but a good break in your… Read more

0 comments, 165 reads

Posted in The Voice of the DBA on 14 December 2018

Synonyms in SQL Server – Good and Bad

When SQL Server 2005 was released, a nifty little feature was included called synonyms.  Despite being around since SQL Server 2005, I think this feature is often under-utilized or, more importantly, it is implemented in a very bad way.

Today I want to share a couple of examples.  We will… Read more

0 comments, 134 reads

Posted in SQL RNNR on 14 December 2018

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server Land

A week is a long time in SQL Server land. This week I have been busy working on a version migration for one particular customer and looking at security, 'productionising' some servers and troubleshooting connectivity issues for another. As is…

Read more

0 comments, 82 reads

Posted in The SQL DBA in the UK on 14 December 2018

ASF 017: Alex Whittles interview

Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack.Alex has an… Read more

0 comments, 97 reads

Posted in SQL Player Blog on 14 December 2018

Setting up CentOS to run docker for SQL Server

This blog post is about running SQL Server in a docker container on CentOS Linux distribution.

This was both an experiment and also for me to re-learn CentOS – years ago I had done a fair bit with CentOS – back when I was a true Operations Consultant. Up until… Read more

0 comments, 121 reads

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

Maintenance Plan Owner – Back to Basics

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit some things that are not so good.  Other times we inherit some things that are just plan annoying.  Yet other times, we inherit things that may be annoying and we… Read more

0 comments, 123 reads

Posted in SQL RNNR on 13 December 2018

Power BI Monthly Digest – December 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our December 2018 edition we highlighted the following features:

  • Smart Guides
  • Field List keyboard shortcuts
  • Control Tab…

Read more

0 comments, 296 reads

Posted in Devin Knight on 13 December 2018

Difference between Restore with Recovery & Restore with Norecovery

Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration procedure means copying the backup and move it to the recovery point. SQL Database recovery involves rolling forward uncommitted transactions and… Read more

0 comments, 92 reads

Posted in Ganapathi's MSSQLLover on 13 December 2018

Change Tracking Inserts Require SELECT Permission

I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions issue on a change tracking table that I’d never encountered before. When attempting to insert data into a change tracking-enabled table using an account with no select permissions, I learned… Read more

2 comments, 119 reads

Posted in Tim Mitchell on 13 December 2018

Things I Learned at Summit v20 - Visual Studio Code

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this post we'll look at a code editing tool that I hadn't seen before - Visual Studio Code.


When I attend a session at a technical event - Summit/SQL Saturday/etc. -…

Read more

0 comments, 130 reads

Posted in Nebraska SQL from @DBA_ANDY on 13 December 2018

Setting up SQL Server replication in containers

Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a container. Now I know very little about replication, it’s not an area of SQL that I’ve had a lot of exposure to but I’m always up for figuring stuff out… Read more

0 comments, 119 reads

Posted in The DBA Who Came In From The Cold on 13 December 2018

The Default Frame for Window Functions

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

This bites me constantly, and I was reminded of this while watching Kathi talk at #SQLintheCity. When you write a Window function, there is an implicit… Read more

1 comments, 196 reads

Posted in The Voice of the DBA on 13 December 2018

Naming Convention Hall of Shame

Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation, or other digital assets, I find a tremendous amount of value in establishing a set pattern for naming and formatting. Especially for organizations with a large digital landscape, having a… Read more

4 comments, 124 reads

Posted in Tim Mitchell on 13 December 2018

The Eleven Days of Festivus 2018

It’s that time again! My Eleven Days of Festivus blogging extravaganza is now in its third year, and I’m happy to share one blog post per day with you for the 11 days between now and Festivus Eve (December 22nd). As before, I’ll link all of the posts from this… Read more

0 comments, 105 reads

Posted in Tim Mitchell on 13 December 2018

SSMS – Docker SQL Server

once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server on Linux to SSMS on you local system, in my case it is windows Pro 10. I have installed SSMS … Continue reading

Read more

0 comments, 156 reads

Posted in Vinay Thakur on 13 December 2018

Older posts