Sites anglophones

SQL SERVER – Adding Datetime and Time Values Using Variables

Publié le 30 octobre 2015 sur journey to sqlauthority

Datetime datatype stores date and time part. If you have only date value, You can add time part to a datetime variable using direct literal value and + operator. It is shown belowDECLARE @date DATETIME SET @date=’2010-10-01’SET @date=@date+’15:00:00’SE …

To tame the Internet of Things, will data miners have to embrace the fog?

Publié le 30 octobre 2015 sur

Michael Morisy PASS Summit’s Day Two keynote challenges industry to make smarter endpoints to tackle immense scale of IoT With questions of scale, « the cloud » is increasingly the answer to tough computing problems. But when it comes to the Internet of …

PASS Summit 2015 WiT lunch

Publié le 29 octobre 2015 sur

A regular spot at the PASS Summit is the Women in Technology lunch. This year is no different. A few years ago, I was on a panel for discussion at the lunch. The last couple of years though, have changed format, and have an interview focus, with a cham …

Internet of Things in 2015 #summit15 #sqlpass

Publié le 29 octobre 2015 sur

David DeWitt and Rimma Nehme delivered the day 2 keynote at PASS Summit 2015 talking about Internet of Things. Many PASS attendees know David for providing some of the best keynotes every, technical and without vaporware and marketing stuffs. So this i …

PASS Summit 2015 – Keynote 2

Publié le 29 octobre 2015 sur

The second day keynote is always a highlight of mine. Until a few years ago there were three keynotes, with the third day including a session from Microsoft Research. Recently this has changed, and the third day keynote rolls into the second. Today I …

PASS Summit 2015 – Keynote Day 2

Publié le 29 octobre 2015 sur

Adam Jorgensen, Executive Vice President Finance and Governance, welcomed the crowd. He pointed out we’re providing 391 hours of education and technical training this year. Adam’s excited about the future growth of PASS, and the need to develop new lea …

Data Mining Algorithms – Decision Trees

Publié le 29 octobre 2015 sur

Decision Trees is a directed technique. Your target variable is the one that holds information about a particular decision, divided into a few discrete and broad categories (yes / no; liked / partially liked / disliked, etc.). You are trying to explain …

Links from my SQLPASS Indexing Precon

Publié le 29 octobre 2015 sur

SQLPASS Selfie with John Honengarten (@wsuhoey) Earlier this week I had a great time teaching a day on index tuning at the 2015 SQL PASS Summit. Along the way I got great questions! Here’s the links that came up to answer them: The Data Loading P …

The ABCs of Database Creation

Publié le 29 octobre 2015 sur

Creating SQL Server databases is easier than the internet may lead us to believe.

SQL SERVER – Who is consuming CPU on my SQL Server?

Publié le 29 octobre 2015 sur journey to sqlauthority

The topics around performance tuning is always interesting and I get quizzed by a number of you during conferences on these topic areas post my presentation. A relatively simple yet a powerful question was asked by one of the attendee in my session at …

PASS Summit 2015 Keynote 1

Publié le 28 octobre 2015 sur

I’m back at the PASS Summit. Another year – my sixth now. And I’m sitting at the bloggers’ table, next to Mark Broadbent (@retracement). The PASS Summit is by far the best SQL Server event in the world each year – even bet …

Announcements at PASS Summit 2015: #SSAS CTP3 and more #sqlpass #summit15

Publié le 28 octobre 2015 sur

I’m sitting at the bloggers table at the Day 1 keynote of PASS Summit 2015 and I try to recap the important news for the BI community. SQL Server Analysis Services 2016 CTP 3 will be available in a few days here, but Microsoft already announced t …

PASS Summit 2015 – Keynote Day 1

Publié le 28 octobre 2015 sur

After this morning’s refreshing three mile SQL Run – a much smaller event this year to avoid the problems inherent in having to get permits for a larger event – and a quick breakfast at the Summit, it’s time for the opening keynote presentation. Tom La …

PASS Summit 2015 kicks off: « This is the age of the data professional. »

Publié le 28 octobre 2015 sur

Michael Morisy A late change in keynote speakers didn’t slow down the momentum for PASS Summit, taking place this week in Seattle, WA. read more

SQL Prompt Tips #3 – Snippet Placeholder $Paste$

Publié le 28 octobre 2015 sur

Another quick tip for SQL Prompt, using the snippets to increase your productivity.

Pages :