Sites anglophones

Splitting Strings: SQL Server 2016 To The Rescue!

Publié le 15 mars 2016 sur

Hold me now! Richie had to break out the fainting couch when I read the release notes for SQL Server 2016 RC0. Why? WHY? Because of one thing. One thing I have watched so many people butcher and bungle over the years (even myself, in about 2009). New B …

Sparse Columns in SQL Server : Impact on Time & Space

Publié le 15 mars 2016 sur

Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.

Documenting SQL Server with PowerShell: PosH VC

Publié le 15 mars 2016 sur

Virtual Chapter meeting, Mar 16, 12pm EST. Documentation is mostly overlooked and only comes up when a problem arises. What if you’d have a tool or method to generate documentation for all your database servers? In this session, Sander Stad will show y …

The Basics of Masking Data in SQL Server 2016

Publié le 15 mars 2016 sur

Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.

SQL SERVER – The Need for Data Tier Elasticity in Cloud Computing

Publié le 15 mars 2016 sur journey to sqlauthority

Many application workloads are characterized by resource use that varies over time. Usage peaks can vary depending on the time of the day, week, or month, and outside events. Even a big sport game or an online sale can bring usage spikes. With traditio …

Creating a Date Dimension in a Tabular Model

Publié le 15 mars 2016 sur

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on …

Building Your Business with Quality Data

Publié le 14 mars 2016 sur

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases–so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain yo …

Why most of you should leave Auto-Update Statistics on

Publié le 14 mars 2016 sur

Oh God, he’s talking about statistics again Yeah, but this should be less annoying than the other times. And much shorter. You see, I hear grousing. Updating statistics was bringin’ us down, man. Harshing our mellow. The statistics would ju …

How to execute an SSIS package from the command line or a batch file

Publié le 14 mars 2016 sur

An SSIS package that is executed on an ad hoc basis can be run from Business Intelligence Development Studio easily enough, but a package that is going to be run on a regular schedule is best executed through a batch file using the DTExec.exe command l …

SQL SERVER – Installing SQL Server Management Studio 2016 – Step by Step

Publié le 14 mars 2016 sur journey to sqlauthority

New versions bring new learning. To keep myself up-to-date, I have downloaded RC0 (release candidate zero) for SQL Server 2016 and while installing SQL Server I was surprised to see the feature list. Installing these bits were something I was wanting t …

What’s New in SQL Server 2016 Release Candidate (RC0)

Publié le 13 mars 2016 sur

Hello SQL folks! Are you still excited that SQL Server will be available on Linux soon? Now, as you probably know the SQL Server 2016 RC0 is now public so everybody can play with it now! You can download the version here You can also go and l …

Interview Question of the Week #062 – How to Find Table Without Clustered Index?

Publié le 13 mars 2016 sur journey to sqlauthority

Question: How to Find Table Without Clustered Index? Answer: In SQL Server, when we create a primary key it automatically creates clustered index on the table, unless we explicitly mentioned not to create one. Due to this reason, the most of the table …

SQL Down Under Show 66–Riccardo Muti and Chris Finlan–SQL Server 2016 Reporting Services

Publié le 13 mars 2016 sur

Hi Folks, I recently got to record a new podcast with Riccardo Muti and Chris Finlan from the SQL Server Reporting Services team. Over recent years, Reporting Services seemed to be in a rut without forward momentum. 2016 however promises to be a really …

[Video] Office Hours 2016/03/09

Publié le 12 mars 2016 sur

Angie, Doug, Richie, and Tara get together for this week’s Office Hours to talk about how many cores you should leave for the operating system, how many unions you should do in a single query, and how often you should install patches. H …

SQL SERVER – Installation Error – File Format is Not Valid

Publié le 12 mars 2016 sur journey to sqlauthority

The reason I love consulting is because I get to see many flavors of the problems. This new avatar for me is pushing the limits to how I keep learning technologies. My recent interaction with client has shown one more error and another angle to look at …

Pages :