Sites anglophones


The Practical Problems of Determining Equality and Equivalence in SQL

Publié le 26 avril 2016 sur sqlservercentral.com
 

In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application’s data types, yo …

SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV

Publié le 26 avril 2016 sur journey to sqlauthority
 

Let us first see script which will return us tablename with schema where clustered index is not a primary key. — Identify table where clustered index is not a primary key SELECT OBJECT_SCHEMA_NAME(so.[object_id]) AS SchemaName, so.name AS Ta …

The SQL Server 2016 Essential Guide: The Modern Data Platform

Publié le 26 avril 2016 sur sqlmag.com
 

Learn about the new features in SQL Server 2016 Learn about the new features in SQL Server 2016 read more

Changing the BI architecture. From Batch to Real-time, from Bulk Load to Message Processing

Publié le 25 avril 2016 sur sqlblog.com
 

In a world of Microservices, CQRS and Event Sourcing is more and more common to have the requirement that the BI/BA solution you’re developing is able to deal with incoming information (more precisely, messages and events) in almost real time. It …

Slide e Demos of my DevWeek sessions are online

Publié le 25 avril 2016 sur sqlblog.com
 

I’ve put on SlideShare and GitHub the slide deck and the demos used in my sessions at DevWeek 2016. If you were there or you’re simply interested in the topics, here’s the info you need: Azure ML: from basic to integration with custom …

A quick tip for working with large scripts in SSMS

Publié le 25 avril 2016 sur brentozar.com
 

Sometimes great things stare you in the face for years Sometimes they stare at you for so long that you stop noticing them. This isn’t a romdramadey tag line. There are just so many buttons to push. Sometimes pressing them is a horrible idea and …

[Video] Office Hours 2016/04/20 – Now With Transcriptions

Publié le 25 avril 2016 sur brentozar.com
 

This week, Brent, Erik, Jessica, Richie, and Tara discuss database modeling tools, how to learn about database corruption, the new cardinality estimator, and the only question that will be on our certification exams. Here’s the vid …

Leverage Analyze in Excel for your Power Pivot model

Publié le 25 avril 2016 sur sqlblog.com
 

Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example, it does n …

A Call for Articles

Publié le 25 avril 2016 sur sqlservercentral.com
 

We’re always looking for articles, but here are a few ones that I’d like to see written up.

Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables

Publié le 25 avril 2016 sur sqlservercentral.com
 

Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.

Verify SQL Backups With SQL Powershell

Publié le 25 avril 2016 sur sqlservercentral.com
 

With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.

SQL SERVER – What is WRK file in Log Shipping?

Publié le 25 avril 2016 sur journey to sqlauthority
 

Several customers use log shipping for disaster recovery across a remote data center. If you are reading this blog, I would assume that you already know SQL Server log shipping If you don’t, then please go through online resources to read the bas …

What is Difference Between HAVING and WHERE – Interview Question of the Week #068

Publié le 24 avril 2016 sur journey to sqlauthority
 

I do a performance tuning consulting to earn my livelihood. Once in a while, I end up customer who wants to interview me to check if I know SQL. I absolutely have no problem with the interview. This is a good thing and it gives me confidence …

PowerShell Script – Backup Every Database In SQL Server

Publié le 23 avril 2016 sur journey to sqlauthority
 

Using scripts can be a powerful way to automate things that a GUI will fail in many cases. I was working with a client who wanted to write a PowerShell script that would help him automate his backups. This is a pretty simple requirement that can be eas …

Increasing Enterprise Workload Availability and Flexibility with HPE Superdome X nPars

Publié le 23 avril 2016 sur sqlmag.com
 

The HPE Superdome X’s unique nPAR capability enables you to provide the required levels of availability as well as the flexibility to handle diverse workloads without the costs incurred by having to buy many smaller commodity servers. read more


Pages :