Sites anglophones


Flash Storage For Dummies

Publié le 1 septembre 2015 sur sqlmag.com
 

In that classic For Dummies style, you’ll get some useful tips on how to best incorporate flash in your IT environment. read more

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Publié le 1 septembre 2015 sur sqlmag.com
 

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N’TableToDrop’ AND type = ‘U’)         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE …

Why is This Partitioned Query Slower?

Publié le 1 septembre 2015 sur brentozar.com
 

It’s tempting to think that table partitioning will improve query performance. After all, it’s an Enterprise Edition feature– it must have a lot of magic, right? Table partitioning does have magic for the right situations. It shines w …

VMware vCloud Air SQL Summarized

Publié le 1 septembre 2015 sur brentozar.com
 

After reading through yesterday’s announcements about VMware vCloud Air SQL, here’s a quick boiled-down version for busy people with jobs: It’s Microsoft SQL Server 2008R2 and 2012 Enterprise Edition hosted in VMware’s data cent …

SSIS Package documentor

Publié le 1 septembre 2015 sur sqlservercentral.com
 

Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.

Free Workshop: Microsoft Data Platform Modernisation – London, Sep 24

Publié le 1 septembre 2015 sur sqlservercentral.com
 

Are you an ISV and/or commercial software developer using SQL Server? Are you considering how to upgrade your application to take advantage of new SQL Server 2014 and would like to know more about how Microsoft can help your migration and sales/marketi …

Selective Updates with ASP.NET SignalR

Publié le 1 septembre 2015 sur sqlservercentral.com
 

Many developers get the misleading perception that ASP.NET SignalR merely helps to build a chat application or provides live updates of news, stock and score tickers. In reality, ASP.NET SignalR has a broader scope. In this article, Dino Esposito cover …

SQL SERVER – Transparent Data Encryption and Frequently Asked Questions

Publié le 1 septembre 2015 sur journey to sqlauthority
 

In the recent past, I have been traveling to Delhi to meet customers and also attend a few conferences which my company has been sponsoring. These travel experiences give me an opportunity to meet folks who read my blog regularly as a face-to-face inte …

SQL 2014 queries under a strobe light

Publié le 31 août 2015 sur sqlblog.com
 

I just wrote a post about Live Query Statistics. Let me show you how this technology in SQL Server 2014 can be used for some amazingly cool (nerdy cool, at least) stuff. Behind the scenes, LQS uses a DMV called sys.dm_exec_query_profiles. When you run …

Consulting Lines: “Keep going. What else?”

Publié le 31 août 2015 sur brentozar.com
 

Some of my consulting lines are all about context. Let’s just jump right into a project kickoff meeting with an architect and a few developers: The Conversation Me: “So, what pains is this SQL Server having?” Phil I. Buster: “Wh …

Power BI Desktop & Excel

Publié le 31 août 2015 sur sqlblog.com
 

The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users:Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop fileLive Analysis Services Connect …

SQL Server 2016 CTP 2.3 – available for download

Publié le 31 août 2015 sur sqlblog.com
 

HelloThe CTP2.3 is ready and waiting for you, SQL Folks! The official statement (by Kevin Farlee), is  as follow:This release includes enhancements to Analysis Services, Database Engine, Integration Services and Master Data Services. The buil …

Live Query Statistics in SQL 2014, not just SQL 2016

Publié le 31 août 2015 sur sqlblog.com
 

One of the coolest things in SQL Server 2016 is Live Query Statistics (LQS). But did you know that it’s available in SQL 2014? The thing is that we haven’t been able to view it effectively before now, before SQL Server Management Studio 201 …

Learning Managed Backup

Publié le 31 août 2015 sur sqlservercentral.com
 

References and Links to using the Managed Backup feature in SQL Server 2016 Free eBook – Performance Tuning with DMVsThis free eBook provides you with the core techniques and scripts to monitor your query execution, index usage, session and transaction …

JSON Select – Easily query values from JSON

Publié le 31 août 2015 sur sqlservercentral.com
 

Introducing JSON Select – a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+


Pages :