70-457 Reviewer #06, Configuring and Managing Database in SQL Server 2012
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
660 reads
Coffee and SQL
70-457 Reviewer #05, Configuring SQL Server 2012 Components
The lessons covered for this review is Configure Analysis Services Configure and Deploy Reporting Services Configure and Deploy Sharepoint Integration...
2013-07-22
580 reads
Rebuilding server level collation setting
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,834 reads
70-457 Reviewer #04, Implement a Migration Strategy
Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012....
2013-07-18
594 reads
70-457 Reviewer #03, Planning an Installation of SQL Server 2012
Planning an installation on SQL Server 2012 is under the Install and Configure SQL Server objective which is 19% of...
2013-07-16
663 reads
Check unused index in SQL Sever 2008
Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for...
2013-07-15
366 reads
2013-07-14
295 reads
MSSQLTIPS SQL Server Webcast
MSSQLTIPS offers new webcast monthly. Topics in various areas of SQL Server are covered and perfect for all DBAs out...
2013-07-12
429 reads
SQL Server Diagnostic Information Queries for July 2013
Reblogged from Glenn Berry's SQL Server Performance: I have gone through and made some minor updates and bug fixes for...
2013-07-11
358 reads
Access denied on your SSIS SQL Server 2008
Scenario. You have a new SSIS server. All DTS packages migrated and deployed successfully to this new SSIS server. You send...
2013-07-11
352 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers