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

Archives: August 2017

We won vs They Lost

Competitive Sports is one of the incredible miracles to me and I love them greatly. I can watch almost any competition where the good sportsmanship is real (Feel free to imagine here your own doping/cheating/stupid exceptions), but there is one thing I can never understand.

WE WON

My countries top… Read more

0 comments, 118 reads

Posted in Niko's blog on 29 August 2017

Tech news: Your phone screen is a dirty rotten spy

Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic (@AdamMachanic) August 29, 2017 OH GOODY, your phone’s screen could totally be spying on you. Great.

The post Tech news: Your phone screen is a dirty rotten spy appeared… Read more

2 comments, 180 reads

Posted in SQL Awesomesauce on 29 August 2017

Power BI Custom Visuals Class (Module 66 – Calendar by Tallan)

In this module you will learn how to use the Calendar Custom Visual by Tallan.  The Calendar Visual provides a calendar layout that filters and aggregates data across a range of dates.

Module 66 – Calendar by Tallan

Downloads

Read more

1 comments, 334 reads

Posted in Devin Knight on 29 August 2017

SQLCLR vs. SQL Server 2017, Part 4: “Trusted Assemblies” – The Disappointment

Recap

Before we look at “Trusted Assemblies”, let’s take a moment to review the context of the situation. First, the “Good”: SQL Server 2017 introduces many awesome features including Linux as a platform, adaptive query processing, interleaved execution for Multi-statement TVFs, and a lot more. Next, the “Bad”: SQL Server… Read more

1 comments, 23 reads

Posted in SQL Quantum Leap on 28 August 2017

Power BI Report Server (On-Premises) for All Data Sources is Available!

Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server [On-Premises], for all Data Sources.

Here’s an excerpt from the Power BI blog post from this weekend:

With this August 2017 preview, users can create Power BI…

Read more

1 comments, 2,732 reads

Posted in SQLvariant on 28 August 2017

The World of MySQL

I had two different people ping me on the same day with MySQL questions. One was a former co-worker, asking for some query help, and one was from the Boy Scouts of America, also asking for some query help for a few reports. Strange that both requests came on the… Read more

3 comments, 234 reads

Posted in The Voice of the DBA on 28 August 2017

Speaking at Live360 Orlando

Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak at SQLServerLive, part of the Live360 event. It takes place November 12-17 at the Royal Pacific Resort at Universal Studios in Orlando.

I’m going to be presenting three different… Read more

2 comments, 254 reads

Posted in The Scary DBA on 28 August 2017

Speaking at Live360 Orlando

Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak at SQLServerLive, part of the Live360 event. It takes place November 12-17 at the Royal Pacific Resort at Universal Studios in Orlando.

I’m going to be presenting three different… Read more

2 comments, 109 reads

Posted in The Scary DBA on 28 August 2017

Create an empty table from a SELECT statement but without the IDENTITY.

A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like this:

SELECT TOP 0 * INTO tableNameArchive FROM tableName

will create a new table with the exact same structure as the source table. It can be a really handy… Read more

3 comments, 2,615 reads

Posted in SQLStudies on 28 August 2017

Contribute to Microsoft Documentation

Times have changed and Microsoft has changed the way we can contribute for documentation!

We already have access to the source code from some programs. One example is PowerShell, that has an GitHub repository where anyone can contribute!

Now anyone can contribute to the documentation too!

How and where?

Read more

2 comments, 31 reads

Posted in Cláudio Silva on 28 August 2017

Microsoft Azure – How to create a virtual machine using PowerShell – Part 1

Hello friends, you can find the post at below link – https://social.technet.microsoft.com/wiki/contents/articles/40000.how-to-create-a-virtual-machine-in-microsoft-azure-using-powershell-part-1.aspx   Tagged: Azure, Microsoft Azure, Powerhsell, Powershell, SQL Azure, Windows Powershell

Read more

0 comments, 269 reads

Posted in Kapil Blogs on 28 August 2017

Monday Coffee: Follow the instructions

Last week I was working on an upgrade and ran into a few issues. Whilst waiting for the company’s support team to come back to me I had a few attempts on my own to resolve the problem but had no luck.

When the support team came back it didn’t… Read more

0 comments, 130 reads

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

Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

Dear All,

Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses Machine Learning using Microsoft Business Intelligence tools in this interview. Leila gives us an insight into Machine Learning process and explains how Azure ML, Power BI, R and…

Read more

0 comments, 1,403 reads

Posted in SQL and SQL Only on 28 August 2017

Getting back to blogging

The past two months have been very hectic for me. I had an unexpected job offer towards end of July, which I gladly accepted – that was followed by some much needed home renovation, and a long vacation/tour of the west coast with my beloved sister. All of this has… Read more

0 comments, 179 reads

Posted in Mala's Data Blog on 28 August 2017

What I Learned Today - Configuring tempdb in RDS

Today I learned that you can configure tempdb in RDS!

One of the things we DBA’s do is configure tempdb to have multiple data files (if needed). Not going to go into the depths of why in this post, but adding multiple data files can help alleviate contention in tempdb.… Read more

0 comments, 224 reads

Posted in cjsommer.com on 28 August 2017

Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)

Continuation from the previous 109 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best possible Segment Elimination for the queries with predicates against… Read more

0 comments, 238 reads

Posted in Niko's blog on 27 August 2017

Azure support MySQL & PostgreSQL

After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL database technologies. this shows that no Microsoft is going to lead the industry by making themselves ready for tomorrow where … Continue reading

Read more

0 comments, 314 reads

Posted in Vinay Thakur on 27 August 2017

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history … Continue reading

Read more

0 comments, 140 reads

Posted in Vinay Thakur on 27 August 2017

Responsible Log Growth with dbatools

I love dbatools, and I’ve been trying to explore the various cmdlets over time, both to practice my PoSh and see if there are easier ways of accomplishing some tasks.

Recently I was browsing the dbatools.io site to see what’s changed and noticed a new cmdlet, Expand-DbaLogResponsibly and just had… Read more

0 comments, 1,430 reads

Posted in The Voice of the DBA on 25 August 2017

Friday Reading 2017-08-25

Great week this week as I’ve been selected to speak at 4 of the SQL Relay events in October! Really chuffed with that as it’s a whole week of talking about SQL Server & Containers! Anyway this week I’ve been reading…

The Trillion Row Table
What happens when you load… Read more

0 comments, 192 reads

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

Newer posts

Older posts