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

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

Generating test data in JSON files using SQL Data Generator

SQL Data Generator is adept at filling SQL Server databases with ‘spoof’ data, for use during development and testing activities. However, what if instead of a SQL Server database full of fake data, you need a JSON file?  Read more...
By 2017/12/11 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,316 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2017/12/08 (first published: 2016/09/26) | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,317 reads

Singular or Plural

A debate that might be worth having in the database community.  Read more...
By Steve Jones 2017/12/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

How Much Data Has Changed Since Your Last Full Backup

Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.  Read more...
By Additional Articles 2017/12/08 | Source: Database Journal | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,764 reads

Free virtual event: SQL in the City Streamed

Technical sessions will dive into the latest Microsoft SQL Server releases, and cover topical issues such as data compliance, protection & privacy.  Read more...
By 2017/12/08 (first published: 2017/11/30) | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,262 reads

How to store Excel files In SQL Table

This article will show how to store images, document and all other files in SQL Table.  Read more...
By Nisarg Upadhyay 2017/12/07 | Source: SQLServerCentral.com | Category: openrowset
Rating: |  Discuss |   Briefcase | 1,792 reads

SQL Server R Services: Working with Multiple Data Sets

Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by passing in a T-SQL query as an argument when calling the sp_execute_external_script stored procedure, you are limited to that one query, unless you pass additional data directly between R and SQL Server via CSV files. It is simple to do, and opens up many additional opportunities for data analysis. Robert Sheldon explains how.  Read more...
By Additional Articles 2017/12/07 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,761 reads

The Relational Database is the Default

If you don't have a good reason not to, use a relational database. Always.  Read more...
By Steve Jones 2017/12/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

Major new study reveals the true ROI of database DevOps

Redgate has launched a new research study that reveals the benefits different stakeholders can expect from DevOps, and provides a powerful methodology for calculating the ROI of database DevOps.  Read more...
By 2017/12/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,388 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2017/12/06 (first published: 2012/10/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,809 reads

Pluralsight is Amazing

Steve appreciates his Pluralsight subscription.  Read more...
By Steve Jones 2017/12/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2017/12/06 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 42,809 reads

Correlation Analysis using Correlation Plot in Power BI Desktop

Power BI provides correlation plot visualization in the Power BI Visuals Gallery to create Correlation Plots for correlation analysis. In this post, Siddharth Mehta shows how to create a correlation plot in Power BI Desktop using a sample dataset of car performance.  Read more...
By Additional Articles 2017/12/06 | Source: MSSQLTips.com | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,091 reads

Keeping tables online during loading with schema swapping using SSIS

In this article, we discuss how schema swapping method can be used to keep tables online during the load process.  Read more...
Rating: |  Discuss |   Briefcase | 835 reads

Can Data Save the World?

The authors of Freakonomics talk data science.  Read more...
By Steve Jones 2017/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 57 reads

Book Review: Database Reliability Engineering by Campbell & Majors

Brent Ozar explains why DBAs should read this book about the future of database administration at scale.  Read more...
By Additional Articles 2017/12/05 | Source: Brent Ozar Unlimited Blog | Category: book reviews
Rating: (not yet rated)  Rate this |   Briefcase | 2,636 reads

Introducing the updated HTML comparison report in SQL Compare 13.1

In SQL Compare 13.1, Redgate have updated the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases. This blog post looks at the details of what's new.  Read more...
By 2017/12/05 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,293 reads

Is This Database Being Used?

Can we delete this database, or is someone still using it?  Read more...
By Ginger Keys 2017/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,622 reads

A Christmas Bug

A bug in American Airlines scheduling could impact travelers, but certainly will impact their bottom line.  Read more...
By Steve Jones 2017/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads

The Appearance of the Flat File Wizard.

After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.  Read more...
By Phil Factor 2017/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads
<< Newer    Items 21 to 40 of 16350    Older >>