Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2015/01/21 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 54,219 reads

SQL Server Reporting Services Basics: Deploying Reports

Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates how to configure reports for native-mode deployment using Report Manager, and then deploy them from within SSDT-BI. She also explains how to use the Report Builder to provide "self-service" reporting to end users, allowing them to build custom reports based on report parts and shared datasets.  Read more...
By Additional Articles 2015/01/21 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 6,288 reads

A Standard Database Security Script Generator

A script generator for standard security compliance.  Read more...
By Jefferson Elias 2015/01/20 | Source: SQLServerCentral.com | Category: generator
Rating: |  Discuss |   Briefcase | 6,243 reads

SQL Prompt Tip #6 - Insert Semicolons

A quick SQL Prompt tip to automatically add semicolons to your code.  Read more...
By Steve Jones 2015/01/20 | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 2,249 reads

The Cost of Switching

With so many companies looking at other platforms, when should an organization consider changing their database? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2015/01/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 159 reads

Move Database Files for a SQL Server Mirrored Database Without Impacting Database Mirroring

Ahmed Yaseen explains how you can move the SQL Server database files without the need to stop and re-create database mirroring.  Read more...
By 2015/01/20 | Source: MSSQLTips.com | Category: database mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 6,641 reads

Untrusted Foreign Keys with NOT FOR REPLICATION Option on the Key

My Foreign Keys are STILL untrusted after the double CHECK. Here's how you can fix this issue.  Read more...
By Brian Hibbert 2015/01/19 | Source: SQLServerCentral.com | Category: untrusted foreign key
Rating: |  Discuss |   Briefcase | 2,089 reads

Questions About Pivoting Data in SQL Server You Were Too Shy to Ask

Of all the basic SQL operations, the pivot seems to cause the most problems. It turns out that there are several questions that come to mind while learning about pivoting, but which are seldom asked on forums.  Read more...
By Additional Articles 2015/01/19 | Source: SimpleTalk | Category: pivot
Rating: (not yet rated)  Rate this |   Briefcase | 9,800 reads

Taking Care of Things Today

Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.  Read more...
By Steve Jones 2015/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 91 reads

Where Microsoft went wrong with SQL CLR

We database developers would, of course, like easy access to all the .NET delights, such as the excellent Regex library, but we don't want a Do-It-Yourself kit to achieve this. So argues Phil Factor.  Read more...
By Phil Factor 2015/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 138 reads

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...  Read more...
By Dwain Camps 2015/01/16 (first published: 2014/04/07) | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 28,894 reads

Debugging SQL Server

This week we have a more technical poll as Steve Jones wonders how you best debug your T-SQL code.  Read more...
By Steve Jones 2015/01/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 129 reads

Returning Sorted Record Sets Using the ORDER BY Clause

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.  Read more...
By Additional Articles 2015/01/16 | Source: Database Journal | Category: order by
Rating: (not yet rated)  Rate this |   Briefcase | 8,961 reads

Prevent sp_ Procedures with SQLCop

Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.   Read more...
By Steve Jones 2015/01/15 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 4,874 reads

Data Cleaning in SQL 2012 with Data Quality Services

Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.  Read more...
By Additional Articles 2015/01/15 | Source: SimpleTalk | Category: data cleansing
Rating: (not yet rated)  Rate this |   Briefcase | 7,827 reads

A Little Empathy

Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.  Read more...
By Steve Jones 2015/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 121 reads

Stairway to PowerPivot and DAX - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2015/01/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,840 reads

Hadoop and SQL Server

Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.  Read more...
By Steve Jones 2015/01/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 223 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/01/14 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 31,397 reads

Options to Improve SQL Server Bulk Load Performance

In this tip Ben Snaidero looks at how to improve SQL Server Bulk Load performance. He focuses his performance tests on options using the BULK INSERT T-SQL command to judge how the various options affect speed.  Read more...
By Additional Articles 2015/01/14 | Source: MSSQLTips.com | Category: bulk load
Rating: (not yet rated)  Rate this |   Briefcase | 6,651 reads
<< Newer    Items 21 to 40 of 13426    Older >>