The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.
2012-01-11
3,322 reads
This SSIS package reads the first line of a CSV file to obtain field names, then creates a table based on those field names and loads the remaining lines into the table.
2012-01-10
13,896 reads
Leibniz breaks out of a buyer's dilemma that might defeat a subtler mind.
2012-01-10 (first published: 2010-06-30)
9,252 reads
Rob Sullivan is one of the users who are helping shape the way that SQL Test develops, and here he explains what is going on, and why.
2012-01-10
1,883 reads
This article describes how to use the built in repository for SQL Server Management Studio Templates and how to customize and share a common repository with your team.
2012-01-09
9,055 reads
Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a defensive approach based on constraints to any team that is developing an application in which the data has to be exactly right, and where bad data could cause consequential severe financial damage. It is perhaps better seen as creating a test-driven database.
2012-01-09
2,574 reads
The challenge is to wrap the text by specified position.
2012-01-09
2,883 reads
The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.
2012-01-06 (first published: 2010-04-12)
52,638 reads
Microsoft Office Word is useful. There, I have confessed it, it's useful to me while I am working with TSQL. It's possibly only the search and replace function that I like but it's wrapped in Word so I have to take it like that. I use it a lot to help me capture the results of a stored procedure.
2012-01-06
4,436 reads
The first part of two parts of a paper discussion the implementation of a "real-world" ETL example using SSIS.
2012-01-05
15,745 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers