Daily SQL Server knowledge direct to your inbox.
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
Daily SQL Articles by email:
Sign up
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,900,073 DBAs, developers and SQL Server users
Headlines today
April 24, 2018
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
|
4,999 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,511 reads
Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes
Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.
Read more...
By
Additional Articles
2018/04/24
|
Source:
MSSQLTips.com
|
Category:
alerts
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,487 reads
Show more
Previous headlines
Cancelling DBCC SHRINKFILE with EMPTYFILE
A fun experiment using DBCC SHRINKFILE to rebalance data.
Read more...
By
Steve Jones
2018/04/23
|
Source:
SQLServerCentral.com
|
Category:
dbcc shrinkfile
Rating:
|
Discuss
|
Briefcase
|
671 reads
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
Read more...
By
Additional Articles
2018/04/23
|
Source:
Database Journal
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
2,435 reads
Spring into the Latest Features at the Luxemborg User Group
The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.
Read more...
By
Additional Articles
2018/04/23
|
Source:
SQLServerCentral.com
|
Category:
user groups
Rating:
|
Discuss
|
Briefcase
|
63 reads
Custom Metrics for Detecting Problems with Ad-hoc Queries
A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this.
Read more...
By
2018/04/23
|
Source:
SimpleTalk
|
Category:
monitoring
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,804 reads
Making Deployments Simpler with Re-runnable Scripts
Make sure your SQL Server database release scripts to make life easier.
Read more...
By
Ed Elliott
2018/04/20 (first published: 2015/11/17)
|
Source:
SQLServerCentral.com
|
Category:
releases
Rating:
|
Discuss
|
Briefcase
|
5,331 reads
How to Show the Execution Plan of a Running Query
By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?
Read more...
By
Additional Articles
2018/04/20
|
Source:
Database Journal
|
Category:
execution plans
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,244 reads
Do you check your backups?
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.
Read more...
By
Michael Higgins
2018/04/19
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
759 reads
From the SQLServerCentral Blogs
Azure SQL Database vCore
vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The...
Read more...
By
Arun Sirpal
2018/04/24
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,354 reads
24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours...
Read more...
By
Thomas LeBlanc
2018/04/24
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,680 reads
Browse all
Question of the Day
Starting Extended Events
By
Steve Jones
2018/04/24
|
Category:
extended events (xe)
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
358 reads
I have an Extended Event (XE) session called "QueryTuning". How do I start this session on my instance in T-SQL?
Read more...
Show more
Latest forum posts
IBM iSeries AS/400 via Linked Server, Inserts a Bracket "}" ...
By
patrickmp1975
|
Apr 24, 2018
Posted to
SQL Server 2016 - Administration
SQLCMD Error ODBC Driver 11
By
trgrassijr
|
Apr 24, 2018
Posted to
Administration - SQL Server 2014
How to remove ALL records with duplicates
By
vujicikm
|
Apr 24, 2018
Posted to
Development - SQL Server 2014
Server role and user mapping lost when apply Dacpac
By
Sue_H
|
Apr 24, 2018
Posted to
SQL Server 2017 - Administration
Cloud Snake Oil
By
qbrt
|
Apr 24, 2018
Posted to
Editorials
New SQL Server articles, scripts and tips every weekday. Get the SSC Newsletter:
Sign up
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.