TechNet Guru Contributions - SQL Server Database Engine
This article lists all SQL Server Database Engine articles that participated in the TechNet Guru Contributions SQL Server Database Engine category.
2018
January 2018
2017
JAN 2017
- SQL Server: Getting Started with MS SQL Server on Red Hat Enterprise Linux by Ryn Kia Zhi Tang -- Gold medal
- SQL Server 2016: JSON integration by Prashant Jayaram - Silver Medal
- SharePoint Troubleshooting: Resolve ‘Cannot connect to database master at SQL Server’ error by** Priyaranjan KS** -Bronze Medal
Feb 2017
- SQL Server 2016: Temporal Tables for Predictive Analytics by pcofre- Gold Medal
- Configure SQL Server 2016 Reporting Services in SharePoint Integrated Mode and Create the First Custom Report by Priyaranjan KS- Silver Medal
May 2017
Working with the Always Encrypted Feature in SQL Server 2016 by Priyaranjan KS** - Gold Medal**
Mssql installation on Centos (Linux) by AV111- Silver Medal
SQL Server on Linux: How to Change SA password by AV111 - Bronze Medal
JUNE 2017
- SQL Server: Understanding Minimal Logging Under Bulk-Logged Recovery Model vs. Logging in Truncate Operation by Mohsin_A_Khan** - Gold Medal**
- Automatic Daily Database Backup To Specific Database In SQL Server by M.Vignesh - Silver Medal
- Options For Monitoring Transactional Replication in SQL Server by** Mohsin_A_Khan -Bronze Medal**
JULLY 2017
- SQL Server 2016: Create Log Backup Maintenance Plan by Mohamed El-Qassas MVP** - Gold Medal**
- Taking Script From Database In SQL Server In Different Mode by M.Vignesh - Silver Medal
AUG 2017
MSSQL command on Linux by AV111 **- Gold Medal **
SQL Script: Convert Rows To Columns Using Dynamic Pivot In SQL Server by ** Mohamed El-Qassas MVP - Silver Medal**
SEP 2017
- SQL Server 2016: Getting the Current Cumulative Update / Service Pack installed by Mohamed El-Qassas MVP - Gold Medal
OCT 2017
Understanding the Internals of Import Flat File Wizard in SQL Server 2017 by Vishakh16 ****- ****Gold Medal
Defragmentation of an index (Reorganize) by Ousama EL HOR - Silver Medal
What is fragmentation in SQL Server? by Ousama EL HOR - Bronze Medal
NOV 2017
SQL Server 2016: Install and Configure SSRS by Mohamed El-Qassas MVP** - Gold Medal**
SQL Server Reporting Services Error: Maximum request length exceeded by Mohamed El-Qassas MVP - Silver Medal
NOV 2017
- SQL Server 2016: Install and Configure SSRS by Mohamed El-Qassas MVP** - Gold Medal**
DEC 2017
- SSRS: Manage Permissions in Reporting Service by Mohamed El-Qassas MVP** - Gold Medal**
2016
January 2016
- SSMS: Using Registered Servers to Manage Servers by FLauffer - Gold Medal
February 2016
- Workaround for Delay in Transaction Log Truncation: Snapshot Replication by FLauffer - Gold Medal
- Benchmark your SQL Server Instance by Florent Duret -Silver Medal
March 2016
- SQL Server 2016 Polybase: How to Query Unstructured Data by Chervine - Gold Medal
- SQL Server Storage: Checking Volumes Block Sizes by Florent Duret -Silver Medal
May 2016
- SQL Server 2016: Stretching tables to Azure by Chervine - Gold Medal
- SQL Server: What does fragmentation means for a Heap Table by Shanky_621 -Silver Medal
June 2016
- SQL Server 2016 Management Studio: Installation by Hezequias Vasconcelos - Gold Medal
- SQL Server Troubleshooting: How to remove a bad execution plan from plan cache by FLauffer -Silver Medal
Jully 2016
- SQL Server PowerShell: Export Server inventory to CSV by Prashanth Jayaram - Gold Medal
- SQL: How to refresh Multiple SQL Databases with PowerShell by Prashanth Jayaram -Silver Medal
AGUST 2016
- SQL Server: Inside a DELETE operation in Heaps by Uwe Ricken - Gold Medal
- SQL Server: Monitoring Disk Space with FSUTIL command line utility by Prashanth Jayaram -Silver Medal
SEP 2016
- SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects by Prashanth Jayaram - Gold Medal
- SQL Script: Passing Parameters to SQL script with Batch File and PowerShell by Prashanth Jayaram -Silver Medal
October 2016
November 2016
Understanding the Internals of Import Flat File Wizard in SQL Server 2017 by Ryen Kia Zhi Tang - Gold Medal
Protect Your Data: Prevent SQL Injection by Vincent Maverick Durano -Silver Medal
PowerShell and SQL : Monitoring Disk Space - XML and ADO.NET Class Libraries by Prashanth Jayaram -Bronze Medal
DEC 2016
- SharePoint: Insert SQL Server data using SQL CLR Trigger and SP Client Object Model by PriyaranjanKS ****- ****Gold Medal
- sQL Server: Ranking Functions by RajeeshMenoth - Silver Medal
2015
January 2015
- SQL Server PowerShell: Export Server inventory to CSV by Uwe Ricken - Gold Medal
February 2015
- SQL Server Books Online by pituach - Gold Medal
- SQL Server: How to Collect Events and Errors by Durval Ramos **** Silver Medal****
March
May
June
- T-SQL: Improve the Performance for LIKE Wildcard by Changing the Collation by Saeid Hasani - Gold Medal
Jully
August
Sepember
Octomber
November
December
2014
December 2014
November 2014
- SQL Server 2012 Memory Change :Do Not Refer to Buffer Pool value in Dbcc Memorystatus and Counter SQL Server Buffer Manager: Target pages by Shanky - Gold Medal
- Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs by Prashanth Jayaram- Silver Medal
- SQL Server Data Tools - Error SQL71501 Unresolved References - An Obscure Cause by Kev Riley - Bronze Medal
October 2014
- SQL Server In depth: What can Cause Index to be Still Fragmented After Rebuild by Shanky** - Gold Medal**
- Representing list of values using a single value by pituach - Silver Medal
- Generate Scripts for Stored Procedures Without Dynamic SQL in SSMS by Visakh16 - Bronze Medal
September 2014
- An Examination of Logging in Truncate Table Statement and Its Comparison With Delete Statement by Shanky - Gold Medal
- SQL Server Load Balancing by Tulio Rosa - Silver Medal
- Get Notified when a database status changes by Ashwin Menon - Bronze Medal
August 2014
- SQL General: Pragmatic Denormalisation by Andy O'Neill - Gold Medal
- Freezing a Table on SQL Server by Durval Ramos - Silver Medal
- SQL GENERAL: Select records from one table based on fields in another table by Ike Ugochuku - Bronze Medal
July 2014
- Cell Level Encryption With Always On Availability Groups by Sean Gallardy - Gold Medal
- How to Install SQL Server 2012 SP2 on Standalone Instance of SQL Server by Shanky - Silver Medal
June 2014
- SQL Server: What does Column Compressed Page Count Value Signify in DMV Sys.dm_db_index_physical_stats ? by Shanky - Gold Medal
- How to get row counts for all Tables by Durval Ramos - Silver Medal
May 2014
- Curious Case Of Logging In Online and Offline Index Rebuild In Full Recovery Model by Shanky - Gold Medal
- SQL Server: Be aware of the correct data type for predicates in queries by Uwe Ricken - Silver Medal
April 2014
- Installing SQL 2014 Step by Step Tutorial by Ronen Ariely [Nickname PITUACH] - Gold Medal
- Importing an Excel Spreadsheet into a SQL Server Database by Durval Ramos - Silver Medal
- find Enterprise-only features in your database by Praveen Rayan - Bronze Medal
- Mis-Understanding of Truncate command by V.Vt
March 2014
- managing database backups across all the instances without maintenance plan by chandra sekhar pathivada - Gold Medal
- Understanding Logging in Tempdb.Is Tempdb re-created or rebuilt after SQL Server restart by Shanky - Silver Medal
February 2014
- Automate Database Migration between SQL Server Instances by Ahmad Osama
- Ghost Rows Buster in SQL Server by Durval Ramos - Gold Medal
- SQL Server:Instant File initialization exception by Praveen Rayan - Silver Medal
- Effective Use of Keyboard shortcuts with SSMS by Jaykumar - Bronze Medal
January 2014
- SQL Server: Misleading Database Initial size Label By Praveen Rayan - Gold Medal
- SQL Server Memory and troubleshooting By Shanky - Silver Medal
- When Using DBCC Shrinkfile for Log files Can we use Truncateonly By Shanky - Bronze Medal
2013
December 2013
- Extract SQL Server Instance Path Dynamically by Manish Maheshwari
- Find Windows and SQL Server Last Restart time by Praveen D'sa
- Log Shipping false error message - 14420 by Praveen D'sa
- How does SQL Server allocate space in a heap by Uwe Ricken - Gold medal winner
November 2013
- SQL Server: Create Random String Using CLR by Ronen Ariely [Nickname PITUACH] - Silver medal winner
- When Foreign Keys will conflict with FILLFACTOR by Uwe Ricken - Gold medal winner
October 2013
- Delete huge amount of data from a relation by Uwe Ricken - Gold medal winner
- What does 'Log Truncation' counter value signifies in DMV sys.dm_os_performance_counters by Shanky_621 - Silver medal winner
September 2013
- SQL Server Performance tuning with Indexing by SathyanarrayananS - Silver medal winner
- Understanding Lock Escalation by Shanky - Gold medal winner
August 2013
- Dropping a clustered index will not reorganize the HEAP by Uwe Ricken - Gold medal winner
July 2013
- Shrink SQL Database during Restore by Ronen Ariely - Gold medal winner
- SQL VDI Backups fail with Error 9001 by Rajukiran L - Bronze medal winner
- SQL Server: No Fragmentation in HEAP from INSERT / UPDATE** **by Uwe Ricken - Silver medal winner
- How to check when index rebuild, update statistics last happened on SQL Server by Mohammad Nizamuddin
See Also
- [[TechNet Guru Contributions]]
- [[SQL Server 2012]]
- List of Award Winning TechNet Guru Articles
- TechNet Guru - All Gold Winner Contributions
- TechNet Guru - All Silver Winner Contributions
- TechNet Guru - All Bronze Winner Contributions
Visakh16
Visakh16
Visakh16
|
AV111 |