Daily SQL Server knowledge direct to your inbox.
Sign up
<a href="//g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
<a href="//g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,902,971 DBAs, developers and SQL Server users
Headlines today
June 19, 2018
SQL Server Database Corruption Detection
How to detect DB corruption ASAP...
Read more...
By
Pauline Xiong
2018/06/19
|
Source:
SQLServerCentral.com
|
Category:
corruption
Rating:
|
Discuss
|
Briefcase
|
636 reads
Reducing risk with Smart Recommendations in SQL Census
Redgate are reducing risk with Smart Recommendations in SQL Census
Read more...
By
2018/06/19
|
Source:
Redgate
|
Category:
data security
Rating:
(not yet rated)
Rate this
|
Briefcase
|
832 reads
Databases with MAXSIZE Set
Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When the 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.
Read more...
By
Additional Articles
2018/06/19
|
Source:
Database Journal
|
Category:
ms sql
Rating:
(not yet rated)
Rate this
|
Briefcase
|
977 reads
Show more
Previous headlines
Jobs You Wouldn't Expect To Be Threatened By Tech But Are
Will there be a fair balance between the coming generations of technology and the human workforce? Here is a list of industries that may not think yes.
Read more...
By
Donna Morgese
2018/06/18
|
Source:
SQLServerCentral.com
|
Category:
ai
Rating:
|
Discuss
|
Briefcase
|
1,338 reads
Idle Connection Resiliency
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
Read more...
By
Additional Articles
2018/06/18
|
Source:
Microsoft MSDN
|
Category:
odbc
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,483 reads
Hyper-V and PowerShell: Shielded Virtual Machines
In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved in the Windows Server 2019 release. In the second part of this series, Nicolas describes what Shielded Virtual Machines are and how to configure them using PowerShell.
Read more...
By
Additional Articles
2018/06/18
|
Source:
SimpleTalk
|
Category:
hyper-v
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,461 reads
Splitting Strings in SQL Server 2016
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
Read more...
By
Wayne Sheffield
2018/06/15 (first published: 2016/04/12)
|
Source:
SQLServerCentral.com
|
Category:
string_split
Rating:
|
Discuss
|
Briefcase
|
5,270 reads
How to Tell If Your SQL Server Has Too Much Memory
Brent shows what Perfmon counter to watch after your SQL Server restarts.
Read more...
By
Additional Articles
2018/06/15
|
Source:
Brent Ozar Unlimited Blog
|
Category:
sql server
Rating:
(not yet rated)
Rate this
|
Briefcase
|
4,036 reads
Finding code smells using SQL Prompt: Asterisk in SELECT list
In this article Phil Factor explains how to find code smells using SQLPrompt: Asterisk in SELECT list
Read more...
By
2018/06/15
|
Source:
Redgate
|
Category:
sql prompt
Rating:
Rate this
|
Briefcase
|
2,438 reads
SQL Server From .Net: Reading SQL Server Metadata in ADO.Net
A basic introduction for developers (or anyone) about reading the metadata of a SQL Server database from a .Net application.
Read more...
By
Tim Wellman
2018/06/14
|
Source:
SQLServerCentral.com
|
Category:
ado.net
Rating:
|
Discuss
|
Briefcase
|
392 reads
From the SQLServerCentral Blogs
Plan Metrics Without the Plan: Trace Flag 7412
I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag...
Read more...
By
Grant Fritchey
2018/06/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,167 reads
Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Demystifying What “sqlservr -q” Actually Does (last updated on 2018-06-19) For various reasons, people sometimes find themselves in the unfortunate (and unenviable)...
Read more...
By
Solomon Rutzky
2018/06/19
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,835 reads
Browse all
Question of the Day
All the memory
By
Steve Jones
2018/06/19
|
Category:
memory
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
491 reads
My SQL Server 2017 instance is a busy system with a high workload. I have 64GB of RAM on the host. What should I set SQL Server to use for...
Read more...
Show more
Latest forum posts
Clustered PK perf -
By
RonKyle
|
Jun 19, 2018
Posted to
T-SQL (SS2K8)
Converting MTVF to In-Line TVF.
By
Feivel
|
Jun 19, 2018
Posted to
SQL Server 2016 - Development and T-SQL
ssrs 2012 blank lines displaying
By
wendy elizabeth
|
Jun 19, 2018
Posted to
Reporting Services
Taking backup with option "Disk = nul"
By
Jeff Moden
|
Jun 19, 2018
Posted to
Backups
Need to get alert
By
Sue_H
|
Jun 19, 2018
Posted to
SQL Server 2017 - Administration
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.
