Sign up for daily SQL Server insight.
Sign up
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,900,190 DBAs, developers and SQL Server users
Headlines today
April 26, 2018
Missing Index Impact and Join Type
Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.
Read more...
By
Additional Articles
2018/04/26
|
Source:
Brent Ozar Unlimited Blog
|
Category:
indexes
Rating:
(not yet rated)
Rate this
|
Briefcase
|
285 reads
SQL Server From .Net: Building a DataSet with Code
A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.
Read more...
By
Tim Wellman
2018/04/26
|
Source:
SQLServerCentral.com
|
Category:
ado.net
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
7 reads
Hash Join Memory Grant Factors
Remember when that old DBA told you not to SELECT *? Erik Darling explains why.
Read more...
By
Additional Articles
2018/04/26
|
Source:
Brent Ozar Unlimited Blog
|
Category:
hash join
Rating:
(not yet rated)
Rate this
|
Briefcase
|
195 reads
Detecting Problems on Databases that use Snapshot-based Transaction Isolation
If you’re using SQL Server’s Read Committed Snapshot Isolation level (RCSI) to avoid long waits for a blocked resource, then you’ll want to monitor for possible side effects. This article describes one way to monitor for such problems, using an alert on version_ghost_record_count, to warn us when the number of row versions in tempdb is getting very high.
Read more...
By
2018/04/26
|
Source:
Redgate
|
Category:
read committed snapshot isolation
Rating:
(not yet rated)
Rate this
|
Briefcase
|
192 reads
Show more
Previous headlines
Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell
In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.
Read more...
By
Ben Miller
2018/04/25 (first published: 2015/12/02)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
5,501 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
2018/04/25 (first published: 2015/05/13)
|
Source:
Redgate
|
Category:
ebook
Rating:
Rate this
|
Briefcase
|
46,543 reads
SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database
Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider. Robert Sheldon explains how to insert, update, and delete rows of Graph Database tables and explains how to use several new helper functions.
Read more...
By
Additional Articles
2018/04/25
|
Source:
SimpleTalk
|
Category:
sql server graph database
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,346 reads
Shift LEFT magazine: Issue 3
The latest issue of Redgate’s Database DevOps magazine explores the benefits of DevOps for CEOs, CIOs, and IT Managers, and takes a comprehensive look at the new General Data Protection Regulation, providing a valuable insight into how organizations can meet its demands.
Read more...
By
2018/04/25
|
Source:
Redgate
|
Category:
devops
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,316 reads
Packaged-Application Database Nightmares - A Horror Story
The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?
Read more...
By
John F. Tamburo
2018/04/24 (first published: 2015/12/22)
|
Source:
SQLServerCentral.com
|
Category:
packaged applications
Rating:
|
Discuss
|
Briefcase
|
5,097 reads
Approaches to masking email addresses
There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.
Read more...
By
2018/04/24
|
Source:
Redgate
|
Category:
data masking
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,927 reads
From the SQLServerCentral Blogs
Execution Plan Shortcoming in Extended Events
I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...
Read more...
By
Grant Fritchey
2018/04/26
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
176 reads
RDS encryption vs TDE
If you’re starting to use cloud services, the number of options available can be confusing. Particularly when they may seem...
Read more...
By
Matthew McGiffen
2018/04/26
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
172 reads
Browse all
Question of the Day
Machine Learning Users
By
Steve Jones
2018/04/26
|
Category:
machine learning services (mls)
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
84 reads
When you install SQL Server 2017 Machine Learning Services with R and Python, how many new users are added to SQL Server by default?
Read more...
Show more
Latest forum posts
Check constraint where all records with the same effective d...
By
sgmunson
|
Apr 26, 2018
Posted to
SQL Server 2012 - T-SQL
Recovery mode reverting to Full
By
Eirikur Eiriksson
|
Apr 26, 2018
Posted to
SQL Server 2016 - Administration
Conditional order by
By
george-178499
|
Apr 26, 2018
Posted to
SQL Server 2008 - General
Duplicating nodes for xml path, combine child nodes
By
quickessayhelp
|
Apr 26, 2018
Posted to
Development - SQL Server 2014
Log shipping
By
dopydb
|
Apr 26, 2018
Posted to
SS2K5 Replication
Fresh SQL server knowledge with daily newsletters:
Sign up
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.