The SQL (Structured Query Language) language is a declarative language that became the "Data Language" used for describing "what I need" and "where to fetch it from" in most organizations. OOP (Object Oriented Programming) languages became the most common practice among developers widely adopted by R&D organizations around the world. So how do we bridge the gap?
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities.
People reading this post might really wonder of having read /heard about a concept on Dependency tracking in SQL Server 2008. It is nothing, but a set of built in existing SYS objects and their effective usage that help us save time & tedious efforts.
Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? We are very pleased to be allowed to publish the first chapter of Grant Fritchey's excellent new book on execution plans.
SQL Server Integration Services is an incredibly rich and complex development environment that can handle almost any data movement task. Even those that do not involve SQL Server. Longtime author Tim Mitchell brings us a use that has nothing to do with SQL Server, but can be very handy for many of us.
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
WhatsApp:0817819444Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah, Kota...
WhatsApp:0817819444Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet Bar.,...
WhatsApp:0817819444Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan, Daerah Khusus...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers