The article Registered Servers vs Central Management Servers lays out the differences in a straightforward manner. Regi
NOTES | Querying Full-Text Data
Creating Full-Text Catalogs and Indexes Full-text search allows approximate searches in SQL Server 2012 databases. Befo
Oracle SQL Developer | Troubleshooting
Seems like the same issue as this one: jtds-driver-not-working-for-sql-sever-2008r2-and-denali-native-sspi-library-not
NOTES | Grouping, and Windowing
SQL Server can perform some data analysis operations. A data analysis function is a function applied to a set of rows, a
NOTES | Filtering and Sorting Data
While the traditional way to filter data in T-SQL is based on predicates, it also supports filtering data based on a spe
NOTES | Combining Sets
Using Joins Often, data that you need to query is spread across multiple tables. The more normalized the environment is
NOTES | Getting Started with the SELECT Statement
Using the FROM and SELECT Clauses The FROM and SELECT clauses are two principal clauses that appear in almost every que
NOTES | Foundations of Querying
Foundations of Querying T-SQL is the main language used to manage and manipulate data in Microsoft’s main relational da
NOTES | A Few Things
In preparing for this exam, my plan is to work my way through each chapter in the Training Kit book, to take notes, gath
Preparation | Exam 70-461 (Querying Microsoft SQL Server 2012)
My current goal is to become a Microsoft Certified Solutions Expert: Business Intelligence. Preparing for the exam I
My goal for 2020/2021 is to become a Microsoft Certified Solutions Expert (MCSE): Business Intelligence. The three Trai
SQL Server offers a broad range of tools and add-ons for business intelligence, data warehousing, and data-driven applic
Docs Bookmark these! * Python 2 documentation * Python 3 documentation * Downloadable PDF of some changes * Why Py
If you spend time around software or internet tools you’ve likely heard the term “API”. API stands for “application prog

Page 1 of 2