Blogs Nikhil Thakkar in Blogs Microsoft SQL Server to Oracle Database Connectivity from SSIS using Attunity Connector Almost every environment now a days need to source data from different source system. Here is how you can establish... 15 June 2021 4 min read
SQL Server Pamela Mooney in SQL Server High availability in SQL Server – a guide (DBA in training, part eight) DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses... 19 May 2021 23 min read
SQL Server Pamela Mooney in SQL Server The basics of SQL Server internals (DBA in training, part seven) In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query... 28 January 2021 27 min read
Databases Pamela Mooney in Databases How to know your server’s limits (DBA in training, part six) Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to... 10 December 2020 15 min read
Career Pamela Mooney in Career How to know your server environment(s) (DBA in Training, part three) It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may... 14 September 2020 11 min read
Career Pamela Mooney in Career How to prepare for a DBA job interview (DBA in training, part two) Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains... 26 August 2020 18 min read
CosmosDB Adam Aspin in CosmosDB Cosmos DB SQL: Querying Complex JSON – Arrays, Schema on Read, and Subqueries Query complex JSON in Azure Cosmos DB SQL: access subnodes and arrays, handle schema-on-read inconsistencies, detect missing attributes, check data... 13 May 2019 16 min read
Blogs Dennes Torres in Blogs Identifying Page Information in SQL Server 2019 SQL Server 2019 has some new and very interesting functions to identify information about pages. Many operations, such as analyzing... 26 February 2019 3 min read
Blogs Dennes Torres in Blogs A real parameterization problem with a plus A few weeks ago I faced this problem: One query on my application was (fortunately in the development environment) was... 12 January 2019 6 min read
Blogs Dennes Torres in Blogs Graph Edge Constraints and a Crystal Ball When I read the list of new features in SQL Server 2019 I became very proud of my crystal ball... 08 December 2018 2 min read
Blogs Dennes Torres in Blogs New Technologies to Study One great result from PASS Summit, especially when we are close to a new SQL Server release, is to identify... 28 November 2018 7 min read
Kalen Delaney SQL Server Internals: In-Memory OLTP In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered... 07 December 2017 2 min read
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking Learn all about Oracle SQL bind variables: the potential issues surrounding bind variables and how to handle them.… 03 February 2017 8 min read
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help... 20 January 2017 9 min read
Enrico van de Laar The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries,... 16 March 2016 7 min read
Laerte Junior The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters Sometimes, it is the small improvements in a language that can make a real difference. PowerShell is able to introduce... 07 March 2016 7 min read
Sander Stad Documenting SQL Server with PowerShell SQL Server instances are generally poorly-documented. How easily can you tell if something has changed? How easily can you check... 11 February 2016 20 min read
Robert Sheldon Five Online Database Modelling Services To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have... 08 February 2016 13 min read
Enrico van de Laar The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings,... 26 January 2016 13 min read
Laerte Junior The PoSh DBA – Towards the Re-usable PowerShell Script When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for... 21 January 2016 17 min read
