New Learning Tree 1 Day SQL Server Training
Learning Tree has recently introduced some new 1 day virtual training events There is range of courses and subjects for...
2015-01-05
891 reads
Blog Posts
Power BI Semantic Model Supports Many-to-Many Relationships
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...
2015-01-05
482 reads
Power BI Semantic Model Supports Many-to-Many Relationships
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...
2015-01-05
429 reads
SQL #56–Aggregation with ROLLUP operator is not fully supported
ROLLUP, CUBE, and GROUPING SETS Operators have been around since SQL Server 2005. These operators are extensions of the GROUP...
2015-01-05 (first published: 2014-12-31)
8,640 reads
Table Variables, CTE and Temp Tables. Which one should I use?
There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...
2015-01-05
1,172 reads
Table Variables, CTE and Temp Tables. Which one should I use?
There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...
2015-01-05
314 reads
Improve Your Wifi Connection Speed with the Use of a Simple 6’/2m USB Cable Extension
For years now we have dropped using Cat6 at home for Wifi,
since the Cat5e cables in the house we moved...
2015-01-04
1,187 reads
Script to find all the running queries/jobs on the Database Server
Below is the query to find out all the Queries and their details like SSID etc. running on the SQL...
2015-01-04
1,602 reads
A Very Happy New 2015
Wishing you a very happy new year to you. May this year bring success & happiness in your life. Reference : Rohit Garg (http://mssqlfun.com/) You can find and follow...
2015-01-03
18 reads
A Very Happy New 2015
Wishing you a very happy new year to you.
May this year bring success & happiness in your life.
Reference : Rohit Garg (http://mssqlfun.com/)
You...
2015-01-03
612 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Bank CIMB Niaga - Dago WA (0813-7071-893)
WhatsApp:08137071893 Jl. Ir. H. Juanda No.165, Lb. Siliwangi, Kecamatan Coblong, Kota Bandung, Jawa Barat...
Bank CIMB Niaga Bandung - Asia Afrika (0813-7071-893)?
WhatsApp:08137071893 Wisma Cimb Niaga, Jl. Gatot Subroto No.2, Burangrang, Kec. Lengkong, Kota Bandung, Jawa...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers