Sites anglophones

SQL SERVER – What are T-SQL Median? – Notes from the Field #090

Publié le 23 juillet 2015 sur journey to sqlauthority

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Median. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I lo …

Utility to reset a sequence next value based on a table/sequence relationship

Publié le 23 juillet 2015 sur

So I was building a database the other day, and I used sequence objects for all of the defaults because it was FAR easier to load data into the table not needing to set identity_insert on and off over and over and over. Worked great. Went through all o …

Finding Tables with Nonclustered Primary Keys and no Clustered Index

Publié le 22 juillet 2015 sur

i’ve seen this happen Especially if you’ve just inherited a database, or started using a vendor application. This can also be the result of inexperienced developers having free reign over index design. Unless you’re running regular he …

DBTA – Does the Looming Shortage in DBAs Spell Opportunity?

Publié le 22 juillet 2015 sur

Originally appearing in my monthly column at Database Trends & Applications magazine . In my last column, available online, I described some of the findings contained in an intriguing new survey sponsored by Ntirety, a remote database administratio …

Azure Event Hubs

Publié le 22 juillet 2015 sur

If you need to receive and process a large volume of of packets of data, such as telemetry, or event-log items, it may be worth considering Azure Event hubs. They aren’t like traditional messaging but represent more of a stripped down one-way event pro …

Free eBook: SQL Server Internals: In-Memory OLTP

Publié le 22 juillet 2015 sur

In this free eBook, Kalen Delaney explains how Microsoft’s new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton …

Stairway to MDX – Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

Publié le 22 juillet 2015 sur

BI Architect Bill Pearson continues with the second of a set of articles surrounding a group of MDX functions specialized to support the analysis of data within the context of time / date. In this article, we will explore the OpeningPeriod() and Closin …

SQL SERVER – Generating Meaningful Test Data with dbForge Data Generator for SQL Server

Publié le 22 juillet 2015 sur journey to sqlauthority

Recently I faced with necessity of generating meaningful SQL data for testing purposes. During my search for a proper application for the task, I found out that Devart, a recognized developer of database solutions, released dbForge Data Generator for S …

New Cardinality Estimator, New Missing Index Requests

Publié le 21 juillet 2015 sur

During some testing with SQL Server 2014’s new cardinality estimator, I noticed something fun: the new CE can give you different index recommendations than the old one. I’m using the public Stack Overflow database export, and I’m runn …

ICYMI – Adding Filtered Indexes, Wait Statistics, Comparing Windows Azure Performance

Publié le 21 juillet 2015 sur

Some of my favorite articles originally appearing at . Dirty Secrets of the CASE Expression Aaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you …

SQL Monitor Custom Metric: Table size (MB)

Publié le 21 juillet 2015 sur

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.

Analyzing I/O Performance for SQL Server

Publié le 21 juillet 2015 sur

Inadequate storage is one of the most common bottlenecks seen in subsystem performance. There are a number of reasons for poor storage performance, but measuring it and understanding what needs to be measured and monitored is always a useful exercise.

Reporting Services: Drawing a Buffer on a Map

Publié le 21 juillet 2015 sur

Handle together SQL Server spatial data features and Reporting Service design tools to build a map-based interactive report. « A real time saver » Andy Doyle, Head of IT ServicesAndy and his team saved time by automating backup and restores with SQL Back …

SQL Server 2012 Service Pack 2 Cumulative Update #7

Publié le 21 juillet 2015 sur

Microsoft has released Cumulative Update #7 for SQL Server 2012 Service Pack 2. This update has 38 fixes, including the QFE security fix from MS15-058 . If you’ve installed MS15-058 (either the QFE – 11.0.5613 – or the GDR – 11.0.5343), you can still i …

SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal

Publié le 21 juillet 2015 sur journey to sqlauthority

There are parts of SQL Server where I always like to take expert advice. Sometimes a quick call to a friend can save you tons of time. When I see topics around AlwaysOn, though I know what the basic steps are to building and working with AlwaysOn, the …

Pages :