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

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

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 | 916 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,042 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,365 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 | 77 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,078 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,863 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,277 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 | 341 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 | 75 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,034 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,126 reads

SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server

SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.  Read more...
By Additional Articles 2017/09/25 | Source: SimpleTalk | Category: sqlclr
Rating:  Rate this |   Briefcase | 5,226 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 | 78 reads

A SQL Server Bug and Data Security

A bug in SQL Server needs patching right away if you use TDE. Some data security issues concern Steve as well.   Read more...
By Steve Jones 2017/09/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 32 reads

Extending DevOps practices to SQL Server databases with ReadyRoll from Redgate

In this webinar, Microsoft MVP Steve Jones and Redgate’s Arneh Eskandari will show you how Redgate’s Database DevOps solution can work to improve your database development and deployment processes. You'll see a demo of the following Redgate tools - ReadyRoll, DLM Automation and DLM Dashboard - and see how they plug into GIT. There will also be plenty of time to ask Steve and Arneh questions.   Read more...
By 2017/09/25 (first published: 2017/09/14) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 8,213 reads

Insert Stored Procedure Results Into New Table Without Using OPENQUERY

OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.  Read more...
By Orlando Colamatteo 2017/09/22 (first published: 2016/03/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,828 reads

The Best of Both Worlds: Using Excel and Power BI Together

Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.  Read more...
By Additional Articles 2017/09/22 | Source: SimpleTalk | Category: excel
Rating:  Rate this |   Briefcase | 4,352 reads

Help from Cortana

Lots of work is going into making software more helpful. This week Steve Jones wonders what you want from these assistants.  Read more...
By Steve Jones 2017/09/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 52 reads

The Avalanche of Cloud Computing

Today Steve Jones talks about the tipping point of cloud computing.  Read more...
By Steve Jones 2017/09/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 51 reads
<< Newer    Items 61 to 80 of 16176    Older >>