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

Latest Blog Posts

Power BI and Data Security – App Workspaces and Power BI Apps

Shortly after I published the Power BI Security Sharing Data post in April, Power BI Premium, Power BI Apps, and Power BI App Workspaces were released. These changes impacted that post in many ways. As part of the follow up, I also did an updated webcast with Pragmatic Works.… Read more

0 comments, 300 reads

Posted in DataOnWheels on 7 August 2017

Database Fundamentals #7: Create a Table Using T-SQL

The syntax for creating a table logically follows many of the same steps that you did when using the GUI, but it will all be done with the statements. This script will exactly replicate everything that you did with the GUI:

CREATE TABLE dbo.Person (
PersonID int IDENTITY(1,1) NOT…

Read more

1 comments, 95 reads

Posted in The Scary DBA on 7 August 2017

SQL Server vs Oracle: Date formatting

Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the other? I’ve decided to start a series comparing these two RDBMS giants and the first topic is date formatting.

Both of these systems use SQL, which is a language used… Read more

1 comments, 24 reads

Posted in Confessions of a Microsoft Addict on 7 August 2017

Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes

I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar will be an introduction to columnstore indexes, which have gained quite some importance since you can now use them in Standard Edition of SQL Server 2016 SP1 or higher.
Title:… Read more

0 comments, 101 reads

Posted in Koen Verbeeck on 7 August 2017

Azure Cloud “Fear” Busting #3 – There is no going back?

Once you go cloud, there is no going back.  This is false and from a database perspective you can migrate back to your own set of servers.

The Challenge: I am going to write about a way to move from Azure SQL Database (Platform as a service) back to a… Read more

4 comments, 203 reads

Posted in All About SQL on 7 August 2017

Limitation of Virtual IP address (VIP) in Microsoft Azure – Part 1

Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a public IP address that can be used to access Virtual machine in Azure. All VM in same domain name share a single VIP. By using a reserved IP address, you…

Read more

0 comments, 208 reads

Posted in Kapil Blogs on 7 August 2017

Dataedo - First Look

Diagraming and Documentation

Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed review on what I've used.

I've recently taken a swing at this newer tool and found it very promising as a database documentation tool that bridged the gap of… Read more

0 comments, 100 reads

Posted in SQL Barbarian on 7 August 2017

SQLSat Planner's Calendar

We just completed our 9th annual SQLSaturday Baton Rouge. In my post-mortem of the event, I've updated and tweaked the living, breathing SQLSaturday Planner's Calendar that I've been crafting for a couple years now.

If you are a SQLSaturday organizer of any level of veterancy, you may find this…

Read more

0 comments, 142 reads

Posted in SQL Tact on 4 August 2017

Power BI and Data Security – Free User’s Cannot Share, Read Only in Premium

As part of the Power BI Premium release, Microsoft changed how the “free users” in Power BI work within the platform. There are two key changes that affect the data security within your organization.

Power BI Free Users Cannot Share

One of the key areas of concern around the free… Read more

0 comments, 219 reads

Posted in DataOnWheels on 4 August 2017

A Day of Data Science with SQL Server, Azure ML, Spark, Hadoop, and R

Hello Dear Reader!  Next week in Jacksonville, Friday August 11th,  I will be presenting a Day of Data Science: With SQL Server 2016/2017, Azure ML, Spark, Hadoop, & R.  We will also be working in some Power BI, and may even be building something like what you see on…

Read more

2 comments, 196 reads

Posted in SQLBalls on 4 August 2017

The 2017 Data Platform Summit

I’m off in a couple days to India for a week of vacation and then the 2017 Data Platform Summit. This is my first time attending, and I’m excited to go. A new country to visit and present in.

In addition to the sessions listed above, I’ve got a pre-con… Read more

0 comments, 216 reads

Posted in The Voice of the DBA on 4 August 2017

Friday Reading 2017-08-04

It’s a bank holiday weekend here in Ireland so I’m looking forward to having the extra day off. Bought a new computer this week so am going to spend a bit of time setting that up (one of my favourite things to do).

One thing to mention is that next… Read more

0 comments, 129 reads

Posted in The DBA Who Came In From The Cold on 4 August 2017

Azure – Storing all cmdlets in a file using Windows Azure PowerShell

Hello friends, windows Azure Powershell has a big library for Azure cmdlets which is very helpful in doing things without logging to Azure portal. In this blog, we will learn how to get all azure cmdlets from PowerShell window and how to import all cmdlets to a text file for…

Read more

0 comments, 185 reads

Posted in Kapil Blogs on 4 August 2017

Beware the automated backup window when running native SQL Server backups in RDS

Beware the automated backup window when running native SQL Server backups in RDS

If you’ve ever fired up an RDS instance you know you can set an automated backup window for your instance. During this window Amazon will kick off an automated snapshot of your RDS instance each day. Set… Read more

0 comments, 274 reads

Posted in cjsommer.com on 4 August 2017

Checking Your Database Properties–#SQLNewBlogger

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

I was reading Grant’s Database Fundamental Series on Database Properties, and it got me thinking. I think this is a good set of knowledge to have, but building… Read more

0 comments, 195 reads

Posted in The Voice of the DBA on 3 August 2017

The times they are ae-changing

I have been quite on this blog for a couple of weeks now, and there are a couple of reasons for this. First of all, it’s the holiday season and I need some rest too

Secondly, I have changed jobs since the 1st of August 2017. This means a lot… Read more

0 comments, 152 reads

Posted in Koen Verbeeck on 3 August 2017

Automating installation of Docker & SQL command line tools on Linux

I’ve been getting to grips with Docker SQL Containers on Linux (specifically Ubuntu 16.04) and have found that I’ve been running the same commands over and over when I’m configuring a new server.

The old adage goes that if you run anything more than once it should be automated, right? Read more

0 comments, 234 reads

Posted in The DBA Who Came In From The Cold on 3 August 2017

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 2

In my previous blog we learnt to connect to Azure subscription by importing azure license setting file. In this blog we will learn an easier method of connecting to azure subscription using Add account method using windows PowerShell. First step is to open the windows PowerShell window. Type the command…

Read more

0 comments, 250 reads

Posted in Kapil Blogs on 3 August 2017

MSBuild and Azure SQL Database

I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to use a local Shadow database in LocalDB and target an Azure SQL Database. I hadn’t build that config, so I decided to give it a try.

I ended up with… Read more

0 comments, 389 reads

Posted in The Voice of the DBA on 2 August 2017

Azure Analysis Services web designer

Microsoft has released a preview of the Azure Analysis Services web designer.  This is a browser-based experience that will allow developers to start creating and managing Azure Analysis Services (AAS) semantic models quickly and easily.  SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) will still be the… Read more

1 comments, 154 reads

Posted in James Serra's Blog on 2 August 2017

Newer posts

Older posts