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

   Items 1 to 20 of 17356    Older >>
 

New Database Options

Steve is looking for where you'd like the database to evolve in SQL Server.  Read more...
By Steve Jones 2018/11/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

Permissions and Security in Dynamic Data Masking

Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.  Read more...
By Steve Jones 2018/11/16 (first published: 2016/06/29) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,070 reads

Batch Mode For Row Store: What Does It Help With?

Considering SQL Server 2019? Erik tells you what kinds of queries will get the biggest performance improvements.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,309 reads

Use SQL Server? We’d like to hear from you.

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. Take part here.  Read more...
By 2018/11/16 | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,306 reads

T-SQL Decommenter Part II

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.  Read more...
By Toby Ovod-Everett 2018/11/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 609 reads

Do you use custom schemas?

Custom schemas have a range of benefits, one a really like is security.  Read more...
By Ben Kubicek 2018/11/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

SOX and Database Administration – Part 3

Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX, passed in 2002, that governs financial data of publicly traded companies in the US.  Read more...
By Additional Articles 2018/11/15 | Source: SimpleTalk | Category: compliance
Rating: (not yet rated)  Rate this |   Briefcase | 1,572 reads

2019 State of Database DevOps – Take the survey!

Database development practices are more integral than ever to DevOps success. How are we saving time, automating processes, deploying more frequently, all whilst keeping business critical data secure? Take part in the survey for an advanced copy of the research report, and a chance to win a $250 Amazon voucher.   Read more...
By 2018/11/15 (first published: 2018/11/26) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,246 reads

The Linux CoC

Some controversy over a new Code of Conduct has risen. Steve thinks we just need treat each other well.  Read more...
By Steve Jones 2018/11/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2018/11/14 (first published: 2015/12/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,522 reads

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.  Read more...
By Press Release 2018/11/14 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 116,317 reads

The Benefits of Adopting Compliant Database DevOps at PASS

The GDPR presented a challenge for PASS - a community of over 250,000 data professionals with almost 300 Local Groups around the world and 24 Virtual Groups. This whitepaper shows how PASS were able to introduce compliance by default with the new data privacy regulations by using Redgate's solutions to apply DevOps practices to the database.   Read more...
By 2018/11/14 | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,220 reads

Fundamentals

Steve Jones stresses the importance of fundamentals.  Read more...
By Steve Jones 2018/11/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

CosmosDB Change Feed Processing

This article was created to help readers understand CosmosDB change feed processing.   Read more...
By Gary Strange 2018/11/13 | Source: SQLServerCentral.com | Category: cosmosdb
Rating: (not yet rated) |  Discuss |   Briefcase | 309 reads

Redgate acknowledged as a representative vendor in Gartner’s 2018 Market Guide for Data Masking

Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking.  Read more...
By Press Release 2018/11/13 (first published: 2018/10/30) | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,024 reads

Overview of In-Memory Technologies of Azure SQL Database

Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-flight transactions. If you are looking for a supplemental approach to enhancing performance, then you might want to consider implementing in-memory technologies which are part of the Azure SQL Database feature set.  Read more...
By Additional Articles 2018/11/13 | Source: Database Journal | Category: in-memory
Rating: (not yet rated)  Rate this |   Briefcase | 1,648 reads

Internal Controls

Steve wonders if there are good internal controls for data access.  Read more...
By Steve Jones 2018/11/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 41 reads

November Data Platform Releases

At the PASS Summit, there are a few announcements of changes to the data platform.  Read more...
By Steve Jones 2018/11/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 24 reads

Linear barcodes in SSRS using the Barcode Image Generation Library

The open source Barcode Image Generation Library enables insertion of twenty-seven different types of linear barcode symbols into SSRS reports without the use of barcode fonts.  Read more...
By Stan Kulp 2018/11/12 | Source: SQLServerCentral.com | Category: ssrs
Rating: |  Discuss |   Briefcase | 639 reads

Getting executive buy in for DevOps - 3 top tips Webinar

In this webinar, Microsoft MVP Kendra Little will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. She will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that transformation.  Read more...
By 2018/11/12 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,059 reads
   Items 1 to 20 of 17356    Older >>