SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 41 to 60 of 16168    Older >>
 

No More Service Packs

There won't be any more service packs for SQL Server after version 2016.  Read more...
By Steve Jones 2017/10/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 82 reads

Data in Motion and Data at Rest

Microsoft (StreamInsight), and Azure Stream Analytics represent a very different model for processing data. They are concerned with processing complex event streams of data (CEPs) from such things as sensors to deduce significant patterns and apply filters. Joe Celko discusses the background to an intriguing technology of complex event processing to establish the difference between data at rest, and data on the move.  Read more...
By Additional Articles 2017/10/03 | Source: SimpleTalk | Category: streaminsight
Rating:  Rate this |   Briefcase | 2,890 reads

So, what is GDPR and why should Database Administrators care?

You’ve no doubt heard at least something about the GDPR, the EU’s new privacy and Data Management law with its greatly increased maximum fines for non-compliance and tighter definitions for acceptable use of personal information. If you’ve continued reading past paragraph one of any of the many articles, you’ll be aware that the law applies globally, to all organizations holding EU citizens’ data – it’s not bounded by geography or jurisdiction.  Read more...
By 2017/10/03 | Source: Redgate | Category: gdpr
Rating:  Rate this |   Briefcase | 3,602 reads

Real-time moving averages for IoT with R

Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.  Read more...
By Nick Burns 2017/10/02 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 444 reads

Get-DbaPowerShell

Steve Jones talks PowerShell and how it is a skill that you might find useful.  Read more...
By Steve Jones 2017/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 71 reads

Should DBAs learn Linux?

Brent Ozar looks at the similarities between SQL Server on Linux and SQL Server on Windows Core from back in 2012, and asks whether DBAs should bother learning it.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,696 reads

The Worms-eye View

Even the most elaborate team-based development methodology won't compensate for the blinkered attitudes and tribal cultures that come from over-specialization in IT.  Read more...
By Phil Factor 2017/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

SQL Prompt Tip: how to control when the suggestion box pops up

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. 90% of the time this is exactly what you want, but there are other times where you just need a bit of space - Phil Factor shows how.  Read more...
By Additional Articles 2017/10/02 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,405 reads

3 Things I Wish I Knew When I Started Using Entity Framework

Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.  Read more...
By Bert Wagner 2017/09/29 (first published: 2016/05/17) | Source: SQLServerCentral.com | Category: entity framework
Rating: |  Discuss |   Briefcase | 5,137 reads

A New New World

What do you see in the future? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2017/09/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Implementing SQL Server Failover Clustering in Azure

Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure.  Read more...
By Additional Articles 2017/09/29 | Source: Database Journal | Category: failover
Rating: (not yet rated)  Rate this |   Briefcase | 2,414 reads

A whole new way to see differences in SQL Compare

In the latest release of SQL Compare, Redgate have added a brand new way to examine the differences between two objects in your database. Jamie Wallis provides the details.  Read more...
By 2017/09/29 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,333 reads

Guide to Create a SQL Central Management Server

This post is going to walk you through the process of creating an SQL Management Server.  Read more...
Rating: |  Discuss |   Briefcase | 914 reads

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.  Read more...
By Additional Articles 2017/09/28 | Source: SimpleTalk | Category: json
Rating:  Rate this |   Briefcase | 3,995 reads

We Have a Date

SQL Server 2017 has a general availability date.  Read more...
By Steve Jones 2017/09/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

Benchmark your Database DevOps maturity level

Whether you’re only just starting to explore the advantages of DevOps or you’re already fully immersed in the journey, including the database brings additional advantages. Take a few minutes to complete our Database DevOps Maturity Assessment and you’ll better understand how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers.  Read more...
By 2017/09/28 (first published: 2017/09/19) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,363 reads

Delightful Database Diversion

A SQL Server Crossword puzzle.  Read more...
By Kenneth Fisher 2017/09/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.  Read more...
By Gregory Larsen 2017/09/27 (first published: 2015/11/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,066 reads

Free eBook: SQL Server Internals: In-Memory OLTP

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.  Read more...
By Press Release 2017/09/27 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 40,861 reads

How to use a Project in SQL Server Management Studio

Matteo Lorini shows how to setup a project in SSMS to organize files.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,269 reads
<< Newer    Items 41 to 60 of 16168    Older >>