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 13433    Older >>
 

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
By David Rueter 2015/01/22 | Source: SQLServerCentral.com | Category: version tracking
Rating: |  Discuss |   Briefcase | 4,884 reads

Getting IT Out of the Data Center

Technology shouldn't just be a cost sink in an organization, at least that's what Steve Jones thinks.  Read more...
By Steve Jones 2015/01/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

Azure SQL Database Auditing

While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.  Read more...
By Additional Articles 2015/01/22 | Source: Database Journal | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 7,155 reads

SQL Monitor Custom Metric: Percentage of Fragmented Indexes

This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If this value indicates an increased amount of index fragmentation throughout your database, you may need to fine-tune your indexes by redesigning, or rebuilding more frequently.  Read more...
By Press Release 2015/01/22 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,612 reads

A Custom Execution Method – Level 19 of the Stairway to Integration Services

The next level of the Stairway to Integration Services looks at how you can execute your package.  Read more...
Rating: |  Discuss |   Briefcase | 2,525 reads

R-E-S-P-E-C-T

There's one word that can make a difference in how much you like your job. Steve Jones has a few thoughts today.  Read more...
By Steve Jones 2015/01/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 161 reads

Tribal Awards 2014 Winners

We have the winners of the 2014 Tribal Awards. Congratulations to everyone involved: winners, finalists, and nominees, and thank you to everyone who voted or nominated someone for an award.  Read more...
By Press Release 2015/01/21 | Source: SQLServerCentral.com | Category: awards
Rating: |  Discuss |   Briefcase | 546 reads

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,984 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,760 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,387 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,288 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,841 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 | 163 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,122 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 | 10,015 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 | 93 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 | 142 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 | 29,077 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 | 133 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 | 9,151 reads
<< Newer    Items 21 to 40 of 13433    Older >>