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

Custom SSMS

This week Steve Jones looks at those customizations that make your job easier.  Read more...
By Steve Jones 2015/01/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 240 reads

Going to Extremes to Release Bug Fixes and New Features

Extreme Programming (XP) is no general panacea; but for the right team, and for a product that needs to release bug fixes and new features as fast as possible, its benefits are obvious. Working on one of Red Gate's most popular tools, SQL Prompt, Aaron Law and David Priddle use XP. But is their adherence to XP a personal preference or does it bring real benefits?   Read more...
By Additional Articles 2015/01/23 | Source: SimpleTalk | Category: extreme programming
Rating: (not yet rated)  Rate this |   Briefcase | 7,269 reads

Webinar: Oracle Exadata & In-Memory Real-World Performance

On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.   Read more...
By Press Release 2015/01/23 | Source: Red-Gate | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 7,063 reads

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,960 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 | 90 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,510 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,928 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,564 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 | 163 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 | 550 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 | 55,418 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,919 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,443 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,307 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 | 7,020 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 | 167 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,139 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 | 94 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,281 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 | 147 reads
<< Newer    Items 21 to 40 of 13436    Older >>