|
|
Latest Blog Posts
-
Microsoft has a new set of on demand webinars to teach you how to use Azure Cosmos DB. Register for them here . You can download the latest version of the Cosmos DB emulator from here . I like it because it can be used offline (great way to learn on those...
|
-
-- this is my version of sp_updatestats Some of you know that SQL Server has a problem with the way statistics are sampled. Indexes in which the lead column is not unique can be adversely affected. My system procedure marks indexes which are either not...
|
-
The Data Modeling for Power BI training is now available as a video recorded course , including exercises!Take advantage of the launch offer until April 17, 2018.Read more about this: Why Data Modeling is important in Power BI The new Data Modeling for...
|
-
I recently published a new blog post on SQLBI. You can read it at this link: https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/ ....
|
-
You have certainly already heard about the new European Regulation 679/2016, better known as GDPR , on the protection of personal data. GDPR is the acronym of General Data Protection Regulation, companies and professionals are required, by May 25 (2018)...
|
-
The company I work for, Perion , chose Amazon Web Services as the main cloud provider for managing and operating our applications. These days I am learning how to manage databases and data related flows in the AWS cloud. Which is the reason I have attended...
|
-
For the last twenty years, the standard practice has been to scale server performance with multi-processor (MP) systems. What is not widely understood is that after processors integrated the memory controller, the initial step from single processor to...
|
-
this is my extended version of sp_helpindex sp_helpindex2 lets face it, sp_helpindex is old and has not been updated for all the new features of SQL Server introduced since the beginning. sp_helpindex provides a list of indexes, information on: the type...
|
-
this is my version of sp_spaceused. Instead of just overall spaceusage, all tables are shown with extended information. -- sp_spaceused2 USE master -- skip this for Azure GO IF EXISTS ( SELECT * FROM sys . procedures WHERE object_id = OBJECT_ID ( 'sp_spaceused2'...
|
-
Most Intel processors use one of two cores, the main-line core and the Atom core. Desktop processors might use the newer Kaby Lake or Coffee Lake micro-architecture cores, while the Xeon SP lines uses the previous generation Skylake micro-architecture....
|
-
SQL Server has always provided tools to manage hierarchies and relationships, facilitating query execution on hierarchical data, but sometimes relationships can become complex. Think about many-to-many relationships, relational databases don't have a...
|
-
It is almost universally accepted without question that the server is a multi-processor system. Long ago, there were valid reasons for this. Over time, the reasons changed but were still valid. When the memory controller became integrated into the processor,...
|
-
I recently published a new blog post on SQLBI. You can read it at this link: https://www.sqlbi.com/blog/marco/2018/02/06/the-new-data-modeling-for-power-bi-course/...
|
-
T-SQL Tuesday #99 invitation......
|
-
I recently published a new blog post on SQLBI. You can read it at this link: https://www.sqlbi.com/blog/marco/2018/02/01/power-pivot-utilities-1-09/...
|
-
I recently published a new blog post on SQLBI. You can read it at this link: https://www.sqlbi.com/blog/marco/2018/01/26/why-i-attend-conferences-and-why-i-speak-at-conferences/...
|
-
Microsoft has released the following Cumulative Updates for SQL Server: Cumulative Update 3 for SQL Server 2017 RTM KB 4052987 Download Build number: 14.0.3015.40 SQL Release Services Blog Post Cumulative Update 7 for SQL Server 2016 SP1 KB 4057119 Download...
|
-
I've moved my content over to sqlblog.org . Read more details......
|
-
Another SQL Saturday has been scheduled in Pordenone (Italy), it will be the SQL Saturday #707 , as last year it will be an international event with international speakers and several sessions in English language! SQL Saturday Pordenone 2018 will be on...
|
-
there is some degree of press hysteria, lawsuits etc. concerning the kernel vulnerabilities of Intel processors with out-of-order execution (which originates to Pentium Pro), so I did a quick check. Earlier, I posted on testing with the TPC-H database...
|
-
The pain of parting is nothing to the joy of meeting again - Charles Dickens It amazes me, but I have blogged here for over 11 years. My first post was about some new functionality in SQL Server 2005, Service pack 2. It was cross posted to drsql.spaces.live.com,...
|
-
Blog has been moved to: jorgklein.com Follow me on twitter: twitter.com/jorg__klein...
|
-
Going home y'all. On January 13th, I will be speaking at the Nashville SQL Saturday. I moved from Nashville less than 1 year ago, and I always look forward to making a trip up (and not just for hot chicken at Big Shakes , though it does figure into it.)...
|
-
From Microsoft-Docs on GitHub : Azure Data Lake Store is an enterprise-wide hyper-scale repository for big data analytic workloads. Azure Data Lake enables you to capture data of any size, type, and ingestion speed in one single place for operational...
|
-
SQL Server Replication usually works just fine when testing in a development environment where there’s low latency and high bandwidth. Real world conditions aren’t always like that. I’ve published instructions on how to use the free WANem network emulator...
|
|
|
|
|