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

   Items 1 to 20 of 16992    Older >>
 

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 | 35 reads

Segment Data into Deciles

This short article shows a simple example of how to segment data into deciles  Read more...
Rating: |  Discuss |   Briefcase | 539 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 | 1,401 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 | 955 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 | 39 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 | 289 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 | 95,911 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,028 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 | 388 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 | 49 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,652 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,439 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 | 64 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 | 339 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,659 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,674 reads

Explicit Transactions

There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.  Read more...
By Steve Hall 2018/07/13 (first published: 2015/12/30) | Source: SQLServerCentral.com | Category: explicit transactions
Rating: |  Discuss |   Briefcase | 5,313 reads

The MVP Award Looks Backward

Steve has a few thoughts on the Microsoft MVP award.  Read more...
By Steve Jones 2018/07/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

What to Do When SQL Server is Slow

Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.  Read more...
By Additional Articles 2018/07/13 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,611 reads

Improving legacy code using SQL Prompt code analysis

Tom Walsh explains how to use Redgate's SQL Prompt to improve legacy code  Read more...
By 2018/07/13 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 1,840 reads
   Items 1 to 20 of 16992    Older >>