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

   Items 1 to 20 of 15747    Older >>
 

Byte Me: Taking it to the top

By Bob Lang 2017/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 22 reads

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?  Read more...
By Hugo Kornelis 2017/05/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Masking your on-premise database with SQL Data Mask

In the last update from Redgate Foundry three weeks ago, they announced their intention to build a version of SQL Data Mask that would mask on-premise SQL Server databases, as well as Azure SQL Databases. They're pleased to say this version of the prototype is now available - here are the details.  Read more...
By Additional Articles 2017/05/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 305 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2017/05/24 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 80,084 reads

Yet another SSIS XML Destination

See a simple script to generate an XML file in SSIS.  Read more...
By Adán Bucio 2017/05/23 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 626 reads

Naming Conventions for the Cloud

Today Steve Jones looks at how you might track the various items you use in the cloud.  Read more...
By Steve Jones 2017/05/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 24 reads

Azure Networking for SQL Server DBAs

The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone get the right access. DBAs generally need not become experts in Azure networks, but it helps to understand the concepts and language. If you are running a SQL Server Virtual Machine in Azure, then VNets, Subnets, Network Security Groups, VNet peering and VPN gateways are all worth knowing about in order to to keep SQL Servers running smoothly.  Read more...
By Additional Articles 2017/05/23 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,114 reads

How to document multiple SQL Server databases using SQL Doc and PowerShell

You can use SQL Doc’s command-line parameters to automate database documentation, but when you try with a group of databases on a server, they sometimes don’t give you enough control over the job. Phil Factor provides a solution that allows both automation and flexibility.  Read more...
By Additional Articles 2017/05/23 | Source: Redgate | Category: sql doc
Rating: (not yet rated)  Rate this |   Briefcase | 1,565 reads

Azure DWH part 9: Azure PHP and ASDW

In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.  Read more...
By Daniel Calbimonte 2017/05/22 | Source: SQLServerCentral.com | Category: php
Rating: |  Discuss |   Briefcase | 220 reads

Security and Patching Struggles

This week Steve looks at the WannaCry attacks and server security.  Read more...
By Steve Jones 2017/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 35 reads

Listening and Taking Action

Microsoft has changed SQL Server in response to the community. Read about some of the enhancements.  Read more...
By Steve Jones 2017/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).  Read more...
By Additional Articles 2017/05/22 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,376 reads

Webinar: Extending DevOps practices to SQL Server databases

In this free demo webinar, Steve Jones and Arneh Eskandari will show how Redgate’s database DevOps solution works to improve your database development and deployment processes. With a focus on using Team Foundation Server (TFS) work items, the webinar will demonstrate how Redgate tools plug into TFS, TFS Build, and Microsoft Release Management. Register now.  Read more...
By Press Release 2017/05/22 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,119 reads

Pseudonymisation

Pseudonymisation is a form of data masking, a technique that becomes more important to data professionals all the time.  Read more...
By Phil Factor 2017/05/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 46 reads

Forecasting with SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.  Read more...
By Mark Wojciechowicz 2017/05/19 (first published: 2010/02/09) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,288 reads

Installing SQL Server Agent on Ubuntu Server

Manvendra Singh explains how to install SQL Server Agent on an Ubuntu server, so that you can create SQL Server Agent Jobs to schedule repetitive tasks.  Read more...
By Additional Articles 2017/05/19 | Source: MSSQLTips.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 1,636 reads

Do you use Visual Studio Code?

Visual Studio Code is rapidly gaining in popularity, but is it all it could be, or is there room for improvement? Redgate is embarking on some research to better understand how you are using this lightweight editor, and where it can be improved. Have your say by filling in this short survey!  Read more...
By Additional Articles 2017/05/19 (first published: 2017/05/17) | Source: Redgate | Category: visual studio code
Rating: (not yet rated)  Rate this |   Briefcase | 4,504 reads

Some of my greatest mistakes

You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.  Read more...
By David Poole 2017/05/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,028 reads

Data Privacy and Security: The Implications of GDPR

There may be new changes to our jobs as data professionals because of GDPR in the European Union.  Read more...
By Phil Factor 2017/05/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 60 reads
   Items 1 to 20 of 15747    Older >>