The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.
2020-04-09
68,970 reads
I am teaching a database class at Queens College. The project entails the truncation of all of the data and loading new data into the existing database "BIClass" from a single of the flattened data. One of the tasks of the project was to add these three additional columns to each of the tables (AlterTableAddColumnsUserAuthorizationKeyAndTwoTimeStamps): […]
2019-11-18 (first published: 2019-11-10)
889 reads
2019-09-24
963 reads
2018-08-16
879 reads
2018-08-02
908 reads
2018-07-26
942 reads
2017-06-29
1,127 reads
This script is for converting Char to nChar and varchar to nVarchar with the same length.
This process has reduced the manual work by 80% (approximately) in our case.
2017-04-24 (first published: 2017-04-10)
535 reads
2012-04-25
3,650 reads
2010-07-14
5,196 reads
Resumes have been on my mind a lot recently. I’ve been thinking that I...
By Steve Jones
Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...
Most of the time when I talk about or demo Extended Events, I spend...
Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...
hi Friends, Requirement: Create a query or Power BI report/dashboard that displays users, their...
hi Friends, Here is the example Scenario: An SSRS Paginated Report has 2 data...
Ask SSC