(Itzik Ben-Gan) Last month I provided a background to table expressions in T-SQL. I explained the context from relational theory and the SQL standard.
Tag: sql server
(Pinal Dave) The primary reason, I keep on writing blog is all of you who keep on asking an interesting question as I publish new blog posts. Yesterday I wrote about SQL SERVER – Performance Test – oStress vs SSMS and later the same day I have received an email from my clients of Comprehensive Datab
(Kenneth Fisher) This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID.
(Daniel Janik) Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a given DMV or table.
(K. Brian Kelley) I’ve heard of a security feature within Microsoft SQL Server called ownership chaining. However, I don’t understand what it is or how it works. When is it applied? What does it affect?
(James Serra) Just announced is Query Acceleration for Azure Data Lake Storage Gen2 (ADLS) as well as Blob Storage.
(Pinal Dave) Earlier on this blog post, I wrote about how one can do the stress testing with the help of oStress in this blog post over here: SQL SERVER – Stress Testing with oStress – Load Testing.
(Chris Webb) In my last two posts (see here and here) I showed you how you can call the new endpoints in the Power BI REST API for exporting a report.
(Grant Fritchey) In this Database Fundamentals post we continue discussing the functionality of the WHERE clause. We started with the basics of the logic using things like AND, OR and LIKE or ‘=’. Now, we’ll expand into some other areas.
(Ray Barley) We have several SQL Server data marts that need to get updated with the daily changes from our main business application database (i.e. our source system) which is a SQL Server database.