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

<< Newer    Items 61 to 80 of 16183    Older >>
 

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,710 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 | 51 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,418 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,156 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 | 56 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,439 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,344 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 | 923 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 | 4,156 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,374 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 | 79 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,086 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,878 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,283 reads

Azure DWH part 16: BCP to import and export data

In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.  Read more...
By Daniel Calbimonte 2017/09/26 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 343 reads

The Problems with Gods

An account with unlimited privileges is potentially an issue.  Read more...
By Steve Jones 2017/09/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 77 reads

What If Week: What Would You Fix Or Change?

Brent Ozar, Erik Darling, and Tara Kizer think about what they would change or fix if they had access to SQL Server’s source code.  Read more...
By Additional Articles 2017/09/26 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,048 reads

When sp_HelpText is not so helpful!

A note of caution on the use of sp_helptext to script out objects.  Read more...
By Andy Robertson 2017/09/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,133 reads

The Flash DBA

Does it make sense for a DBA to be a job that moves from project to project? Steve Jones has some thoughts.  Read more...
By Steve Jones 2017/09/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads
<< Newer    Items 61 to 80 of 16183    Older >>