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

   Items 1 to 20 of 16996    Older >>
 

The Challenge of Failure and of Being Unwired

About to embark on a vacation, Steve talks about the difficulty in letting go.  Read more...
By Steve Jones 2018/07/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

SQL Server Migration

Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.  Read more...
By Geoff Ruble 2018/07/20 (first published: 2015/10/12) | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 4,699 reads

SQL Code Analysis from a PowerShell Deployment Script

Database code analysis becomes more important as the team doing the database development gets bigger and more diverse in skills. In this article Phil Factor discusses SQL Code Analysis from a PowerShell Deployment Script  Read more...
By 2018/07/20 | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,529 reads

Why SQL Developers Keep Making The Same Mistakes

They learned by reading your old code.  Read more...
By Additional Articles 2018/07/20 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,646 reads

The Combinations of Software

The weakest link in the chain of software is a problem.  Read more...
By Steve Jones 2018/07/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Segment Data into Deciles

This short article shows a simple example of how to segment data into deciles  Read more...
Rating: |  Discuss |   Briefcase | 623 reads

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.  Read more...
By Additional Articles 2018/07/19 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,008 reads

Making the database key to DevOps with comprehensive, customizable monitoring

The speed of business today demands that the development and deployment of applications is fast-moving, with frequent yet error-free releases. That’s why the adoption of DevOps is trickling down from Amazon, Facebook, Google and the other usual suspects to every company that relies on technology to drive its communications or sales with users.  Read more...
By 2018/07/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,445 reads

Storage that Expires

Azure has a new write once storage option with lifecycle management options.  Read more...
By Steve Jones 2018/07/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database

In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.  Read more...
By Arun Sirpal 2018/07/18 | Source: SQLServerCentral.com | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 314 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 2018/07/18 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 96,161 reads

SQL Server Reporting Services Rest API

What functionality is available in the SQL Server Reporting Services REST API and how should you use it?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,337 reads

Setting Permissions to Drop a Database

Learn which permissions are required to drop a database and see a test to show that these apply.  Read more...
By Steve Jones 2018/07/17 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 402 reads

The End of Support

With SQL Server 2008 coming out of support, will you upgrade?  Read more...
By Steve Jones 2018/07/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Help Redgate do a better job (and win a $250 Amazon voucher)

Could you spare a few minutes to help Redgate improve its products and services? They’re running a survey of their users and the wider SQL Server community and they’d appreciate your insights. As a thank you for taking part, you’ll also be entered in a prize draw for a $250 Amazon Voucher.   Read more...
By 2018/07/17 (first published: 2018/07/09) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,841 reads

Using SQL Server's Default Trace to Identify Autogrow Events in tempdb

We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately.  Read more...
By Additional Articles 2018/07/17 | Source: Database Journal | Category: default trace
Rating: (not yet rated)  Rate this |   Briefcase | 1,661 reads

The Age of Multiple Databases

There are lots of databases to choose from. Steve discusses using more of them in your work.  Read more...
By Steve Jones 2018/07/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 65 reads

Fixing ‘A required Privilege is not held by client’ Error

This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out . A required privilege is not held by the client. The step failed.   Read more...
By Vishnu Gupthan 2018/07/16 | Source: SQLServerCentral.com | Category: required privilege
Rating: |  Discuss |   Briefcase | 347 reads

Deploying Multiple Databases from Source Control using SQL Change Automation

Phil Factor demonstrate how to use SQL Change Automation, to take the contents of a source control directory for a database, check that it is possible to build from it, document it and then create a NuGet package and place the code in it  Read more...
By 2018/07/16 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 1,877 reads

T-SQL Window Functions and Performance

T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.  Read more...
By Additional Articles 2018/07/16 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,923 reads
   Items 1 to 20 of 16996    Older >>