Power BI and Data Security – App Workspaces and Power BI Apps
Shortly after I published the Power BI Security Sharing Data post in April, Power BI Premium, Power BI Apps, and...
2017-08-07
849 reads
Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
188 reads
Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
296 reads
SQL Server vs Oracle: Date formatting
Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the...
2017-08-07
319 reads
Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar...
2017-08-07
294 reads
Azure Cloud “Fear” Busting #3 – There is no going back?
Once you go cloud, there is no going back. This is false and from a database perspective you can migrate...
2017-08-07
439 reads
SQLCLR vs. SQL Server 2017, Part 1: “CLR strict security” – The Problem
The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...
2017-08-07
2,363 reads
Limitation of Virtual IP address (VIP) in Microsoft Azure – Part 1
Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a...
2017-08-07
592 reads
Dataedo - First Look
Diagraming and Documentation
Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed...
2017-08-07
750 reads
Dataedo - First Look
update 2019-02-22
Image links broken. Since their product is continually improving, I'm going to just link to their product here instead so you can review their latest demo content there....
2017-08-07
16 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers