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,908 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:
(not yet rated)
|
Discuss
|
Briefcase
|
119 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
|
349 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
|
379 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,239 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,319 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,231 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,210 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
|
3,797 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,296 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
|
373 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
|
701 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-15) 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
|
853 reads
Browse all
Question of the Day
All the memory
By
Steve Jones
2018/06/19
|
Category:
memory
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
121 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
State v Migrations
By
t.franz
|
Jun 19, 2018
Posted to
Editorials
All the memory
By
Steve Jones - SSC Editor
|
Jun 19, 2018
Posted to
Discuss Content Posted by Steve Jones
Encrypted connections to the database
By
M Joomun
|
Jun 19, 2018
Posted to
Administration - SQL Server 2014
Computed columns best practices.
By
Grant Fritchey
|
Jun 19, 2018
Posted to
Design Ideas and Questions
Partitioning on sql azure db? is it possible?
By
Grant Fritchey
|
Jun 19, 2018
Posted to
SQL Azure - 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.
