Sites anglophones


Avoid these Four Critical DBA Mistakes

Publié le 3 juin 2016 sur sqlmag.com
 

Database Admins: Don’t make these common errors. read more

SSMS 2016: It Just Runs More Awesomely

Publié le 3 juin 2016 sur brentozar.com
 

Step 1: configure SSMS to only show file names on the tabs. Click Tools, Options, Text Editor, Editor Tab and Status Bar, and set all of the tab texts to false except file name. After all, not like all this stuff fits on the tab. Step 1: SSMS tab name …

Licensing and upgrade options for Analysis Services Tabular in SQL Server 2016 #ssas #tabular

Publié le 3 juin 2016 sur sqlblog.com
 

With the release of Microsoft SQL Server 2016, there are several options to use Analysis Services Tabular. SQL Server Standard: it includes Analysis Services Tabular, and it is available in two licensing models: Server + Client Access License (CAL) and …

Is your SAN’s cache killing tempdb?

Publié le 3 juin 2016 sur brentozar.com
 

Let’s start with definitions Many SANs have caching built in. What kind of cache is important, because if you’re dealing with non-SSD storage underneath, you could be waiting for a really long time for it to respond. Let’s start with …

Installing SQL Server 2016 Developer Edition, One Example

Publié le 3 juin 2016 sur sqlblog.com
 

There are lots of options when installing SQL Server 2016 Developer Edition. I am not going to exhaust them. I will, however, share how I set up SQL Server 2016 to begin learning about the relational engine, SSIS, and SSRS. First, you need SQL Server 2 …

The End of Big Data

Publié le 3 juin 2016 sur sqlservercentral.com
 

What is next for big data? Some experts claim that data « volumes, velocity, variety and veracity » will only increase over time, requiring more data storage, faster machines and more sophisticated analysis tools. However, this is short-sighted, and does …

OmniCompare: How do your SQL Servers differ?

Publié le 3 juin 2016 sur sqlservercentral.com
 

When you have an issue on standardized kit, your first question is usually what’s changed or how is this server different to the others. Has a setting been changed? A job disabled? Aireforge OmniCompare was developed to help diagnose such issues, …

Using LAST_VALUE

Publié le 3 juin 2016 sur sqlservercentral.com
 

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!

Auto-Injection of Enterprise Edition Features

Publié le 3 juin 2016 sur sqlblog.com
 

There’s an interesting scenario that’s come up in creating some new samples for SQL Server 2016. I know that for many, many years people have asked for a way to limit developer edition to only use standard edition features, or at least to h …

SQL SERVER – Maintain Carriage Return (Enter Key) in SQL Server 2016 Management Studio While Copy and Paste

Publié le 3 juin 2016 sur journey to sqlauthority
 

With every new release some of the default behavior can surprise because you are so much used to them. But when they don’t behave the same, it baffles to when some of these changes were introduced. In pursuit of finding such behavior, while I was …

24 Hours of PASS (May 2016): Recordings Available!

Publié le 2 juin 2016 sur sqlblog.com
 

The sessions of the event 24 Hours of PASS The Evolution of the Data Platform edition (held the last May 2016 on 25 and 26) were recorded and now they are available for online streaming!  If you have missed one session in particular or t …

BI Beginner: Using Power BI Desktop Instead of Excel for Visualizing Big Data

Publié le 2 juin 2016 sur sqlblog.com
 

Excel is a great tool but never intended for working with Big Data or even very large csv files. The 64-bit version of Excel is better at processing large files than the 32-bit version, but even it has limitations. Power BI Desktop (BI as in Business I …

SQL Server 2016 Developer Edition is Free

Publié le 2 juin 2016 sur sqlblog.com
 

You can now download SQL Server 2016 Developer Edition – which is Enterprise Edition functionality with a license that forbids using the platform for Production purposes – for free. How? Join Visual Studio Dev Essentials. Once you join (for …

So You Want to Learn More About Biml?

Publié le 2 juin 2016 sur sqlblog.com
 

Biml is growing in popularity and it’s so cool to be a part of this awesome and growing community! This is not an exhaustive list, but here are some places you can go to learn and read more about Biml: Resources BimlScript.com Varigence Biml Foru …

#DellDBADays 2016: What Would You Do with Unlimited Hardware?

Publié le 2 juin 2016 sur brentozar.com
 

Last August, we got the team together in person for Dell DBA Days. We ran all kinds of interesting experiments with SQL Server, and shared the results with you via live webcasts. You can watch our recorded episodes from last year – I’d …


Pages :