Business Intelligence/Data Warehouse Assessment
When I am tasked to do a business intelligence or data warehouse assessment, the steps I take to do that...
2014-01-09
2,035 reads
James Serra's Blog
SQL Server 2014 In-Memory OLTP (Hekaton) Limitations
One of the biggest new features in SQL Server 2014 is SQL Server In-Memory OLTP, known mostly by its code...
2014-01-07
4,157 reads
Power BI Q&A Preview now works on your data
As I mentioned in Power BI first impressions, Power BI Q&A is an instantaneous search experience that uses a natural language query....
2014-01-02
728 reads
Entity Data Modeling with Visual Studio
While there are a lot of tools out there for data modeling, there is one option that is free if...
2013-12-30 (first published: 2013-12-26)
13,057 reads
Power Query load settings
One point of confusion I see with Power Query is some people believe Power Query adheres to the Excel limit...
2013-12-23
1,399 reads
I’m presenting at the PASS Business Analytics Conference
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA...
2013-12-19
654 reads
Power Query Preview December Update
Microsoft keep turning out updates to Power Query. For December, some of the new features (download):
Connection to three more data...
2013-12-17
951 reads
Power BI for Office 365 FAQ
As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback,...
2013-12-12
1,782 reads
Certification Updates for SQL Server 2014
Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL...
2013-12-10
5,411 reads
Power Query Preview November Update
As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft...
2013-12-05
1,507 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Semanggi Telpon/WA:08137887595
BCA KCP Semanggi Telpon/WA:08137887595.Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Bend. Hilir, Kecamatan...
BCA KCP GAMA Telpon/WA:08137887595
BCA KCP GAMA Telpon/WA:08137887595.Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
BCA KCP Palmerah Telpon/WA:08137887595
BCA KCP Palmerah Telpon/WA:08137887595.Jl. Palmerah Barat No.38 A, Grogol Utara, Kec. Kebayoran Lama, Kota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers