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

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

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,864 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 | 762 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 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,587 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

The Importance of Consistent Server Setup

In larger shops with multiple database servers, it is very important to have consistency.  Read more...
By Ben Kubicek 2018/10/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.  Read more...
By Andy Jones 2018/10/12 (first published: 2016/03/28) | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 3,807 reads

Finding & Fixing Statistics Without Histograms

Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.  Read more...
By Additional Articles 2018/10/12 | Source: Brent Ozar Unlimited Blog | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 2,732 reads

Redgate University has opened its doors online

Redgate has established the Redgate University, an online resource where you’ll find self-paced training courses with easy to follow classes to help you and your team learn the fundamentals and best practices, and get top tips from the experts.  Read more...
By 2018/10/12 | Source: Redgate | Category: redgate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,884 reads

Self-Healing ETL

AI might be coming to the ETL work near you.  Read more...
By Steve Jones 2018/10/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 71 reads

HTTP Requests Using SQLCLR

Query web APIs directly in SQL Server with its CLR integration  Read more...
By Eilert Hjelmeseth 2018/10/11 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 878 reads

Fifty Different Ways to Enact Data Privacy Laws?

Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.  Read more...
By Additional Articles 2018/10/11 | Source: SimpleTalk | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,419 reads

Collecting Data with Elastic Database Jobs in SQL Azure

In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.  Read more...
By Additional Articles 2018/10/11 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,218 reads

Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework

This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.  Read more...
By Andy Leonard 2018/10/10 | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated) |  Discuss |   Briefcase | 279 reads

Normal Data

More and more people are starting to perform data analysis, including DBAs, but they should be aware of what normal means for data.  Read more...
By Steve Jones 2018/10/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 180 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2018/10/10 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 102,477 reads

Get SQL Server Row Count and Space Used with the sp_rows

Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.  Read more...
By Additional Articles 2018/10/10 | Source: MSSQLTips.com | Category: row count
Rating: (not yet rated)  Rate this |   Briefcase | 3,139 reads

Single Source of Truth

Andy Warren talks about the single source of truth for information. It could be the database, but that's not always the best choice.  Read more...
By Andy Warren 2018/10/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

SSIS Basics: Bulk-Import various text files into a table

For this post I will show you how to bulk insert multiple files in a folder to a SQL Server database, regardless the file name or extension, this with the help of the ForEach Loop Container.  Read more...
Rating: |  Discuss |   Briefcase | 845 reads

Databases with MAXSIZE Set

When a database grows to the MAXSIZE the database will not grow anymore and if someone tries to add more rows they will get an error saying the database is full. Greg Larsen shows you how to find all database files that have their max_size set.  Read more...
By Additional Articles 2018/10/09 | Source: Database Journal | Category: maxerrors
Rating: (not yet rated)  Rate this |   Briefcase | 2,337 reads
<< Newer    Items 21 to 40 of 17274    Older >>