PASSMN Rocks 2012!
As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN. I...
2012-02-22
590 reads
DataOnWheels
PowerPivot and Market Research
This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...
2012-02-16
592 reads
PowerPivot for Excel Install Issues
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
981 reads
Microsoft Data Appliances Help Simplify MSBI Projects
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
627 reads
X on XMLA: i. Using XMLA
In my previous blog, I introduced the “X on XMLA” series. In this blog, I will do more of an...
2012-01-26
657 reads
Introducing “X on XMLA”
XMLA or XML for Analysis is used in SQL Server Analysis Services and other multidimensional data systems to manage the...
2012-01-19
545 reads
Why It’s Called a User Group…
On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year. As...
2012-01-18
565 reads
How I Got Started in Software Development-A Tribute to Ed
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
506 reads
Why I Blog – #Meme15
A fellow blogger and SQL guy, Jason Strate (@stratesql) started a meme on Social Networking as a result of a...
2011-12-15
557 reads
Upgrading Denali CTP3 to SQL Server 2012 RC0
When I started looking into the upgrade path for this, I saw a couple of notes online about the fact...
2011-12-05
782 reads
Blogs
The Book of Redgate: Customer Quotes
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
Forums
Life Moves Pretty Fast
Comments posted to this topic are about the item Life Moves Pretty Fast
Parse XML data from SQL table using temp tables and variables
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
50 Years of Microsoft
Comments posted to this topic are about the item 50 Years of Microsoft
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers