Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
382 reads
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
382 reads
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
519 reads
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
406 reads
This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...
2018-10-16
445 reads
We are often required to pass the data between different database procedures and functions. In this post I will review...
2018-09-06
318 reads
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,766 reads
I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...
2018-05-21 (first published: 2018-05-09)
2,502 reads
In this post you will find two small functions that convert binary value to a decimal one and vice versa.
2018-05-19
415 reads
Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this...
2018-05-10
613 reads
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on...
2018-04-14
1,295 reads
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
Comments posted to this topic are about the item Create an HTML Report on...
While doing some housekeeping activity on several old but large production databases, I come...
How important to SQL Server is the speed of the SSD and network latency?...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers