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

   Items 1 to 20 of 17269    Older >>
 

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008  Read more...
By Kenneth Igiri 2018/10/19 (first published: 2016/01/18) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 3,103 reads

Horrible Bosses

Having a bad boss is one that Steve tries to avoid.  Read more...
By Steve Jones 2018/10/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads

Your SQL Server is Bored: What Low Wait Times Mean

In which you ask your assistant to fetch your coffee, and time them.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,780 reads

The 4 pillars of SQL Server Monitoring

In this new whitepaper, 5 SQL Server experts; Grant Fritchey, Rodney Landrum, Kathi Kellenberger, Phil Factor and Tony Davis, use their many years of experience working and maintaining data systems to explain the 4 key strategies required for a successful, estate-wide monitoring solution.   Read more...
By 2018/10/19 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,991 reads

Using your critical eye to see something positive

As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.  Read more...
By Ben Kubicek 2018/10/18 | Source: SQLServerCentral.com | Category: critical
Rating: (not yet rated) |  Discuss |   Briefcase | 31 reads

Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server

Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.  Read more...
By Deepak Prasad Sahu 2018/10/18 | Source: SQLServerCentral.com | Category: audit specification
Rating: |  Discuss |   Briefcase | 359 reads

Creating Machine Learning Applications using Azure Cognitive Services

Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.  Read more...
By Additional Articles 2018/10/18 | Source: SimpleTalk | Category: machine learning (ml)
Rating: (not yet rated)  Rate this |   Briefcase | 1,842 reads

Join Kendra Little at SQL in the City to capture the value of DevOps

Kendra Little is giving a 75-minute session on ‘Capturing the Value of DevOps’ at the upcoming SQL in the City Summits in New York City on October 12, London on October 18, and Chicago on October 26. The Summits are for C-level IT executives, directors, managers, and senior database engineers and administrators interested in learning about all things DevOps.  Read more...
By 2018/10/18 | Source: Redgate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 1,416 reads

Using Tools That Fit

The right tool is important for a good job. Andy Warren asks if you're thought about the tools you use on a daily basis.  Read more...
By Andy Warren 2018/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

Installing the Database Server - Level 2 of the Stairway to SQL Server on Linux

In this next level, we learn how to install SQL Server on Linux and verify that everything is working.  Read more...
By Danilo Dominici 2018/10/17 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 245 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2018/10/17 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 100,585 reads

Using Azure Quickstart Templates

In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.  Read more...
By Additional Articles 2018/10/17 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,590 reads

Selling Automation to Ops

Steve Jones thinks that DevOps is the wave of the future for most companies. He has a few ways to try and bridge the gap between development and Operations groups.  Read more...
By Steve Jones 2018/10/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 143 reads

Using Redgate API to compare data in the same table

I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.  Read more...
By Ben Kubicek 2018/10/16 | Source: SQLServerCentral.com | Category: redgate
Rating: |  Discuss |   Briefcase | 484 reads

Configuring a MySQL Database on Amazon RDS

Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.  Read more...
By Additional Articles 2018/10/16 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,466 reads

Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt

This article is all about using a SQL Prompt snippet to create and run a test harness on a batch of SQL code, to provide performance data. Behind the scenes, the snippet creates and starts an Extended Events event session, inserts and runs the text of the batch of SQL you’ve selected in SSMS, and uses XQuery on the XML event data, to return it in digestible, tabular form.  Read more...
By 2018/10/16 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,829 reads

Being Careful with Schema Ownership

When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.  Read more...
By Steve Jones 2018/10/15 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 761 reads

A Primer on Defect Management

Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.  Read more...
By Additional Articles 2018/10/15 | Source: SimpleTalk | Category: defects
Rating: (not yet rated)  Rate this |   Briefcase | 1,553 reads

Modeling and Design Are More Important in DevOps

Steve notes that modeling and good database design can't be ignored in DevOps work.  Read more...
By Steve Jones 2018/10/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

A $3 Billion Donation

Microsoft opens 60,000 patents to the Open Inventor Network.  Read more...
By Steve Jones 2018/10/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads
   Items 1 to 20 of 17269    Older >>