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

<< Newer    Items 21 to 40 of 15764    Older >>
 

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 | 81,407 reads

Yet another SSIS XML Destination

See a simple script to generate an XML file in SSIS.  Read more...
Rating: |  Discuss |   Briefcase | 765 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 | 34 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:  Rate this |   Briefcase | 2,040 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:  Rate this |   Briefcase | 2,363 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 | 265 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 | 46 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 | 45 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,985 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,776 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 | 52 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,434 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 | 2,165 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,914 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,127 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 | 67 reads

Using the DbFit Framework for Data Warehouse Regression Testing

It is ironic that the users of database application need to rely on the very technologists that created the system to then devise and run their acceptance tests. Surely someone has devised a test system for databases that is simple enough for ordinary tech-savvy people to use and for them to create the tests? Yes they have. Fitnesse DbFit is a mature product that can, and does, test SQL Server databases, and Nat Sundar explains how to set it up and do it.  Read more...
By Additional Articles 2017/05/18 | Source: SimpleTalk | Category: data warehouse
Rating:  Rate this |   Briefcase | 2,663 reads

How Redgate helped define a truly automated database deployment process

At the end of 2016, Redgate interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools, and also to find out what lessons he learned during the process - the highlights make for interesting reading. Read the interview write-up.  Read more...
By Additional Articles 2017/05/18 | Source: Redgate | Category: automated deployment
Rating: (not yet rated)  Rate this |   Briefcase | 2,565 reads

Array Element by Agonizing Array Element

Iterations and loops are fundamental parts of computer science, but with SQL and PowerShell, we may want different programming paradigms.  Read more...
By Phil Factor 2017/05/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 59 reads
<< Newer    Items 21 to 40 of 15764    Older >>