Greg Smith

Registered Servers vs Central Management Servers

The article Registered Servers vs Central Management Servers lays out the differences in a straightforward manner. Registered Servers Connection data is stored locally in an XML file (passwords are encrypted) in the user path. Because it is a local file with encrypted data, Registered Servers are local and only work for the user that created them. Can be used with SQL Server Authentication or Windows Authentication. Can be used for the database engine, SSAS, SSIS and SSRS. Central Management Servers Connection data is stored in a central SQL Server (in the msdb database), and can be used by other users. Can be… Read More

Swift vs Python in 2020

Python and Swift are two free, open-source tools for iOS app development that are in high demand as the resultant code looks elegant with minimal but comprehensive features. It seems that Swift with 48.2K GitHub stars and 7.71K forks on GitHub have more adoption than Python with 25K GitHub stars and 10.3K GitHub forks. But Python has a broader approval, being mentioned in 2789 company stacks & 3500 developers stacks; compared to Swift, which is listed in 979 company stacks and 526 developer stacks. Swift is relatively newer than Python. Subsequently, Python has a larger community and more followers. Swift vs. Python: Is Swift similar to Python? Feature Comparison Python Swift Definition Python is an object-oriented… Read More

The Swift community is amazing

It’s really good to see that there are still plenty of dedicated people who are keeping up writing about the good and bad parts of iOS / Swift development. Here are the best resources that you should know in 2020. Best iOS / Swift tutorial sites Ray Wenderlich AppCoda Best iOS / Swift blogs Paul Hudson John Sundell Antoine van der Lee Vadim Bulavin Keith Harrison Majid Jabrayilov Bart Jacobs Soroush Khanlou Erica Sadun Andrew Bancroft Best iOS / Swift newsletters iOS Goodies iOS Dev Weekly Swift Developments Indie iOS focus weekly Best iOS / Swift podcasts… Read More

NOTES | Querying Full-Text Data

Creating Full-Text Catalogs and Indexes Full-Text Search Components In order to start using full-text search, you have to understand full-text components. For a start, you can check whether Full-Text Search is installed by using the following query. If Full-Text Search is not installed, you must re-run the setup. You can create full-text indexes on columns of type CHAR, VARCHAR, NCHAR, NVARCHAR, TEXT, NTEXT, IMAGE, XML, and VARBINARY(MAX). Besides using full-text indexes on SQL Server character data, you can store whole documents in binary or XML columns, and use full-text queries on those documents. Columns of data type VARBINARY(MAX), IMAGE, or… Read More

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 You should drop the appropriate ntlmauth.dll file from the JTDS download package into your JRE bin folder. If you’re running on a 64bit Windows machine: This 32bit DLL:Downloads >>> >>> x86 >>> SSO >>> ntlmauth.dll Goes here in this 32bit JRE location:C:\Program Files (x86)\Java\jre7\bin This 64bit DLL:Downloads >>> >>> x64 >>> SSO >>> ntlmauth.dll Goes here in this 64bit JRE location:C:\Program Files\Java\jre7\bin If you’re running on a 32bit Windows machine: This 32bit DLL:Downloads >>> >>> x86 >>> SSO >>> ntlmauth.dll Goes here in this 32bit JRE location:C:\Program Files\Java\jre7\bin If that doesn’t… Read More

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, and it returns a single value. An example of such a function is the SUM aggregate function. A data analysis function can be either a group function or a window function. The two types differ in how you define the set of rows for the function to operate on. You can use grouped queries to define grouped tables, and then a group function is applied to each group. Or, you can use windowed queries that define windowed tables, and… Read More

NOTES | Combining Sets

Using Joins Often, data that you need to query is spread across multiple tables. The more normalized the environment is, the more tables you usually have. The tables are usually related through keys, such as a foreign key in one side and a primary key in the other. Then you can use joins to query the data from the different tables and match the rows that need to be related. Cross Joins A cross join is the simplest type of join, though not the most commonly used one. This join performs what’s known as a Cartesian product of the two… Read More

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 specified number of rows and ordering. To do so, use TOP and OFFSET. Filtering Data with Predicates ON, WHERE, and HAVING are the three query clauses which enable your filtering of data based on predicates as supported by T-SQL. Predicates, Three-Valued Logic, and Search Arguments Not all filtering aspects are obvious, but you need to understand how to form a predicate to maximize query efficiency and how predicates interact with NULLs; for this, you will need to be familiar… Read More

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 query that retrieves data. When you execute a SELECT statement, it usually retrieves one or more rows of information – the exact number depends on how you construct the statement. These rows are collectively known as a result set. Brief summary of the clauses in a SELECT statement: The FROM Clause FROM – This is the second most important clause in the SELECT statement and is also required. You use the FROM clause to specify the tables or views from… Read More

NOTES | Foundations of Querying

Foundations of Querying T-SQL is the main language used to manage and manipulate data in Microsoft’s main relational database management system (RDBMS), SQL Server—whether on premises or in the cloud (Microsoft Windows Azure SQL Database). It all stems from the mathematical principals of set theory and predicate logic. T-SQL is a dialect of standard SQL and therefore the core elements look the same. However, all leading database vendors decides which features to implement and which to not. Also, each vendor usually implements extensions to the standard in cases where the vendor feels an important feature is not covered by the… Read More