Sites anglophones

Supercharge Your Virtualized Microsoft SQL Server 2014

Publié le 1 juin 2015 sur

Maintain high throughput in VMware environments- increase infrastructure versatility & reliability using Microsoft SQL Server 2014 and HP Light Endurance PCIe Workload Accelerators. read more

BetOnSoft Beats the House with Fusion ioMemory ioDrive cards

Publié le 1 juin 2015 sur

After website traffic more than doubled over a 12-month period and the development team was faced with significant challenges to create performance headroom. See why Fusion ioMemory with Microsoft SQL Server 2012 was the right solution. read more

Session 3: DAX Expressions

Publié le 1 juin 2015 sur

Running Time: 63 minutes | This session will cover the creation of advanced measures and analytics within the model using DAX expressions. We will use the CALCULATE() function along with various filtering, date, and table functions to create time analy …

Session 1: Loading Data into the Model

Publié le 1 juin 2015 sur

Running Time: 68 minutes | This session will cover the process of loading data into the model. We will look at working with various types of data sources. We will pull whole tables, as well as use queries to pre-aggregate data as part of the load proce …

Session 2: Refining the Model

Publié le 1 juin 2015 sur

Running Time: 59 minutes | This session will cover the process of refining the data in the model. This will include setting various attributes of the tables and the columns to improve functionality. We will also create relationships and hierarchies wit …

How to Set Up Standard Edition AlwaysOn Availability Groups in SQL Server 2016

Publié le 1 juin 2015 sur

SQL Server 2016 adds Availability Groups in Standard Edition. While the licensing details can obviously change right up to release date, here’s what was announced at the Ignite conference: Limited to two nodes only (a primary and a secondary) Lik …

SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)

Publié le 1 juin 2015 sur journey to sqlauthority

As I always say, Errors are a great source of learning and I am fortunate to have you as my readers. Because one of my blog reader reported an interesting issue which is worth blogging. This is his initial email: Hi Pinal, Your blogs have been very hel …

Interview Question of the Week #022 – How to Get Started with Big Data?

Publié le 31 mai 2015 sur journey to sqlauthority

Big data is one of the most popular subject in recent time and everybody wants to get started on this subject. During recent interviews there are plenty of the questions with related to Big Data. Here is the most popular question which I receive on thi …

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

Publié le 30 mai 2015 sur journey to sqlauthority

When I wrote the previous post around SQL SERVER – CREATE TABLE Failed Because Column ‘C1024′ in Table ‘myTable’ Exceeds the Maximum of 1024 Columns, I thought it was a simple concept. Lesser did I know that there can …

SQL SERVER – Using 20 Logical Processors Based on SQL Server Licensing

Publié le 29 mai 2015 sur journey to sqlauthority

It is second to human nature to utilize every bit of juice for what we pay. You buy something and you would like to get the best out of it right? If you start thinking from an organizations point of view, they think they should buy something which sati …

AlwaysOn Availability Groups and SQL Server Jobs, Part 25: Final Remarks on Backups

Publié le 28 mai 2015 sur

In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage database backups against AlwaysOn Availability Group databases. Most of the information I’ve provi …

Interesting Upcoming Intel Processors

Publié le 28 mai 2015 sur - glen berry

There has been quite a bit of leaked news and rumors about several future Intel processor families over the past couple of weeks, from what I consider to be pretty reliable sources. I’ll start out with the desktop and mobile processors and then m …

Contest: Write the Scariest DBA Sentence (10 words or less)

Publié le 28 mai 2015 sur

Warm up your keyboard, it’s time for a contest. The challenge: Write the creepiest sentence you can come up with. You get 10 words max. An example to get you started: Oh, I’m sure someone set up the backups. The rules: Enter as often as you …

SQL SERVER – What are T-SQL Window Functions? – Notes from the Field #082

Publié le 28 mai 2015 sur journey to sqlauthority

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about easy and amazing functions of SQL Server. Kathi is an amazing instructor, she was the SQL author I have read in my ea …

Reusing T-SQL Code

Publié le 28 mai 2015 sur

Database programmers are often caught in the paradox of wanting to implement business rules and complex functionality in one place only, but being concerned by the performance hit of having generic functions or procedures that have a wide range of para …

Pages :