Sites anglophones

SQL SERVER – Configuring Startup Options for SQL Server Management Studio

Publié le 28 octobre 2016 sur journey to sqlauthority

Yesterday I started my day early to get to a gym. I know this was the first day and I had loads of work pending to be completed at work too. This got me busy and I started to drive my car, oblivious of the fact that I had to take a turn which I missed. …

Triggers: Threat or Menace?

Publié le 27 octobre 2016 sur

The original SQL-86 standard did not have TRIGGERs. In fact it did not have much of anything! My favorite omission to the standard was that you could grant privileges to a user, but you could not revoke them. Talk to security officers about this and se …

PASS Summit 2016 – Keynote 2

Publié le 27 octobre 2016 sur

Thursday! Kilt day. We start with Grant Fritchey (PASS’ VP of Finance, in a kilt), talking about the various metrics of PASS, which show that the community is growing both numerically and graphically, reaching 87% of countries now. It’s goo …

Dummies Guide for a SQL Server Presentation

Publié le 27 octobre 2016 sur

Preparing for SQL Server presentations is always a challenge. This article provides a few guidelines for the same

Microsoft Announces Azure Analysis Services Preview at PASS Summit 2016

Publié le 27 octobre 2016 sur

The PASS Summit – the largest conference for Microsoft Data Professionals – kicked off the 2016 event in Seattle today with a number of exciting announcements; including news about Analysis Services availability on the Azure cloud platform. read more

At SQL PASS, a vision of analyzing any data, anywhere, by anyone

Publié le 27 octobre 2016 sur

Michael Morisy The democratization of analytics means more opportunities in the SQL world There’s a lot of news coming out of SQL PASS Summit 2016, and the annual gathering only just begun. At the keynote, Joseph Sirosh, corporate vice president of Mic …

SQL SERVER – Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list

Publié le 27 octobre 2016 sur journey to sqlauthority

With SQL Server 2016, I have come to know some of the restrictions which were applicable earlier are no longer the limits to look for. In one such experimentation is what I stumbled upon the blog post: SQL SERVER – Fix: Error: Msg 1904, Leve …

Azure SQL Data Warehouse free — for a month

Publié le 26 octobre 2016 sur

Take Azure SQL Data Warehouse for a spin risk free with new trial program Who doesn’t like getting something free? At SQL PASS Summit 2016, Microsoft announced free month-long trials of SQL Data Warehouse between now and December 31, 2016. read mo …

At SQL PASS 2016, Microsoft releases beta of Cognitive Toolkit 2.0

Publié le 26 octobre 2016 sur

Michael Morisy Satya Nadella’s vision for Microsoft: Be the « Gutenberg Press » of the AI age At SQL PASS Summit 2016, Microsoft’s been making a number of announcements that go beyond SQL and into the future of how data is analyzed. One of those announce …

Sending Results of DBCC CHECKDB SQL Agent Job Via Email

Publié le 26 octobre 2016 sur

Sending the results of DBCC CHECKDB is not too difficult but there is a couple of things that, if you’ve not dealt with before, will serve as issues with successfully architecting a solution. read more

At SQL PASS 2016, Microsoft unveils public preview of Azure Analysis Services

Publié le 26 octobre 2016 sur

Michael Morisy Self service BI, now as a service As Michael Otey noted last week, there’s a lot going on at SQL PASS this year. One of the big announcements: Azure Analysis Services public preview. Initially available in South-Central US …

Importing Excel Data into Power BI Desktop

Publié le 26 octobre 2016 sur

For many organizations, Microsoft Excel remains a critical tool for recording, calculating, and sharing data, especially when it comes to number crunching and disseminating vital information. Those workbooks contain a great deal of important data, and …

PASS Summit 2016 – Blogging again – Keynote 1

Publié le 26 octobre 2016 sur

.So I’m back at the PASS Summit, and the keynote’s on! We’re all getting ready for a bunch of announcements about what’s coming in the world of the Microsoft Data Platform. First up – Adam Jorgensen. Some useful stats abou …

My How to Think Like the Engine Class is Now Free – and Open Source

Publié le 26 octobre 2016 sur

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. You’ve never had a formal database internals …

Real-time Operational Analytics in SQL Server 2016 – Part 2

Publié le 26 octobre 2016 sur

Arshad Ali discusses the different design considerations for leveraging the Real-time Operational Analytics feature of SQL Server 2016, covering the different scenarios where it fits or does not fit, and how to get started with it for disk based tables …

Pages :