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

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

Practical usage of SQLCLR: Building QueryToHtml function

This article shows a few techniques with SQLCLR to to transform a query result into HTML.   Read more...
By Darko Martinovic 2017/06/05 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,320 reads

Big Power Issues

The British Airways IT disaster showcases some poor technology architecture.  Read more...
By Steve Jones 2017/06/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

Where is my SQL Server Configuration Manager?

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,909 reads

Simplifying the user access audit with SQL Census

SQL Census is the latest piece of technology to be developed within Redgate Foundry. Still early in its development, it’s a product that’s designed to help you explain to an auditor which of your colleagues are able to access business-critical SQL Server databases. Here's how it works, and how you can get involved with the early access program.  Read more...
By 2017/06/05 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,421 reads

Presentations that are Easy on the Eyes

Today Steve Jones talks presentations, specifically the best way to share information on a projector.  Read more...
By Steve Jones 2017/06/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.  Read more...
By Mickey Stuewe 2017/06/02 (first published: 2016/01/04) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,145 reads

Free ebook: Stairway to SQL Server XML

Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML.  Read more...
By Additional Articles 2017/06/02 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 4,476 reads

Introducing DLM Techniques for a Multi-Database Multi-Server System

Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems, what if the database 'layer' consists of several large interdependent databases and data flows with replication and audit? Does DLM scale to this level of complexity? Margaret Cruise O'Brien starts a series of articles that describes the practicalities of improving DLM within an existing framework and team supporting a multi-database multi-server system, by describing some of the database management problems and solutions in an enterprise-scale database.  Read more...
Rating:  Rate this |   Briefcase | 2,355 reads

Database DevOps Training

This is aimed at anyone responsible for SQL Server schema changes. The course teaches how to manage database changes throughout their lifecycle, helping to deliver more frequently and more reliably. London, September 25 - 27 2017.  Read more...
By 2017/06/02 | Category: training
Rating: (not yet rated)  Rate this |   Briefcase | 2,666 reads

PowerShell Scripting to Replicate Cloud & SaaS Data to SQL Server

Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell  Read more...
By Jerod Johnson 2017/06/01 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 391 reads

Performance Myths : Truncate Can't Be Rolled Back

Derik Hammer sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.  Read more...
By Additional Articles 2017/06/01 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 4,062 reads

Consider the Downside

Steve Jones asks software developers to consider the issues we may have with lax internal security.  Read more...
By Steve Jones 2017/06/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

The language of DevOps ROI

How do you quantify the value of DevOps? The answer might depend on what value actually means for your organization, which stakeholder you’re talking to, and what type of lens they’re looking through.  Read more...
By Additional Articles 2017/06/01 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,403 reads

Stairway to U-SQL Level 14: Local U-SQL Scalar Functions with C#

Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.  Read more...
By Mike McQuillan 2017/05/31 | Source: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 521 reads

DNA for Data Storage

Data storage is something all data professionals need to care about, and today Steve Jones talks about a research project from Microsoft.  Read more...
By Steve Jones 2017/05/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2017/05/31 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 84,842 reads

Tempdb size resets after a SQL Server service restart

Have you ever checked the size of the SQL Server tempdb after restarting SQL Server to find that it's reset? Simon Liew explains this behaviour.  Read more...
By Additional Articles 2017/05/31 | Source: MSSQLTips.com | Category: tempdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,892 reads

Validate Integer and Decimal Values in SQL Server

Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.  Read more...
By Additional Articles 2017/05/31 | Source: MSSQLTips.com | Category: sql
Rating:  Rate this |   Briefcase | 2,427 reads

Comparing and Synchronizing Two Folders with Azure

In this article, we will compare two folders using PowerShell, the command prompt and other tools.  Read more...
By Daniel Calbimonte 2017/05/30 | Source: SQLServerCentral.com | Category: compare
Rating: |  Discuss |   Briefcase | 272 reads

SQL Server Temporal Tables: How-To Recipes

Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other. How do you create one, or modify an existing table? How can you get an In-Memory Optimized OLTP table to be Temporal? Alex Grinberg shows how.  Read more...
By Additional Articles 2017/05/30 | Source: SimpleTalk | Category: temporal tables
Rating:  Rate this |   Briefcase | 3,277 reads
<< Newer    Items 61 to 80 of 15843    Older >>