Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

   Items 1 to 20 of 15146    Older >>

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2016/10/21 (first published: 2015/08/31) | Source: | Category: json
Rating: |  Discuss |   Briefcase | 11,465 reads

Your Technology Budget

How much do you love technology? Is this reflected in a budget? Let us know this week.  Read more...
By Steve Jones 2016/10/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

SQL Server 2014 Build List

A list of builds for SQL Server 2014, through CU9 for SP1.  Read more...
By Steve Jones 2016/10/21 (first published: 2015/02/23) | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 5,684 reads

Memory/Storage Technology Hierarchy and SQL Server

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.  Read more...
By Additional Articles 2016/10/21 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 2,000 reads

Where Do You Run Your R Scripts?

Executing R scripts can be a heavy load. Today Steve Jones wonders if SQL Server is the best place to execute these.  Read more...
By Steve Jones 2016/10/20 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 45 reads

Basic Data Manipulation for Relational Data in R

In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.   Read more...
By Mala Mahadevan 2016/10/20 | Source: | Category: r programming
Rating: |  Discuss |   Briefcase | 868 reads

SQLServerCentral team in Seattle

The team behind will be in Seattle at the PASS Summit next week, and we’d like to hear from you. If you’re heading to the event, we’d love to get feedback on how you use the site, and hear about any changes you’d like to see. If you’d be willing to have a quick chat, please email us, and we’ll set up some time with Steve and the team.  Read more...
By 2016/10/20 | Source: | Category: pass summit
Rating: (not yet rated) |  Discuss |   Briefcase | 1,692 reads

Getting started with Query Store feature in SQL Server 2016 – Part 3

Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.  Read more...
By Additional Articles 2016/10/20 | Source: Database Journal | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 1,929 reads

One Million

The number one million has special meaning to many people. And it's a heck of a metric to achieve in a measurement on a database system.  Read more...
By Steve Jones 2016/10/19 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2016/10/19 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 77,644 reads

Join Redgate at PASS Summit 2016

This year Redgate have a breakout session featuring SQL Clone, as well as a booth in the exhibit hall. They'll be giving away all sorts of prizes including SQL-themed playing cards, flying sheep, and a year's worth of the world's strongest coffee! To find out the details of what they'll be up to between October 25 - 28, and to find out how you can attend the exclusive #RedgateRocks party, read this blog post.  Read more...
By 2016/10/19 | Source: Redgate | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 1,078 reads

PowerShell Just Enough Administration

A major difficulty for a System Administrator who wishes to provide access for auditors, Helpdesk staff, developers and other IT people is that adminstrator roles give users more access than they need. It is too easy to make mistakes, or to make more changes than those that were signed-off. With JEA, it is possible to create role-based access control (RBAC) endpoints that define precisely what actions you’ll let your users carry out without needing a elevated, privileged administrator credentials, and which log and report all operations.  Read more...
By Additional Articles 2016/10/19 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 1,686 reads

Archaic Commands

Today Steve Jones reminisces about the command line. 
By Steve Jones 2016/10/18 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

Time Traveling with Temporal Tables on SQL Server 2016

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.  Read more...
By Johan Åhlén 2016/10/18 | Source: | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 1,493 reads

Automatically upload SQL Server Database Backups to Azure with Integration Services

Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups.  Read more...
By Additional Articles 2016/10/18 | Source: | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,103 reads

Developing Redgate’s SQL Toolbelt

Take a look behind the scenes to learn more about Redgate’s development challenges, what role the SQL Toolbelt plays, and which releases are coming up.  Read more...
By Additional Articles 2016/10/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,429 reads

Free Webinar: Redgate DLM Demo

Learn how to use Redgate’s DLM solution to improve your database change management process in our free webinar on October 18th. Microsoft Data Platform MVPs, Steve Jones, and Grant Fritchey, will demonstrate how Redgate’s tools plug into Git, Jenkins & Octopus Deploy so that you can build, test and deploy your database alongside your application code. Register now.  Read more...
By 2016/10/18 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,727 reads

Using OVER() to Fix Bad Version Numbers

See how the OVER() clause was used in a live system to fix overlapping field version numbers.   Read more...
By Mike McQuillan 2016/10/17 | Source: | Category: over
Rating: |  Discuss |   Briefcase | 1,844 reads

In-Memory OLTP: Row Visibility in SQL Server’s MVCC

SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by arranging for each user connected to the database to see a snapshot of the rows of the tables at a point in time, No changes made by the user will be seen by other users of the database until the changes have been completed and committed. It is conceptually simple but does the user always see the correct version of a row under all circumstances? Shel Burkow explains.  Read more...
By Additional Articles 2016/10/17 | Source: SimpleTalk | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 1,751 reads
   Items 1 to 20 of 15146    Older >>