Error: No mapping between account names and security IDs was done
I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a...
2012-09-04
10,724 reads
The INSTALLSHAREDWOWDIR command line value is not valid.
I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly...
2012-08-28
1,406 reads
Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.
If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message:
We’ve...
2012-08-21
1,142 reads
Modify Host File on Windows 7
Modifying the Windows host file can be a great way to ensure that you don’t accidentally modify production while doing...
2012-08-14
1,137 reads
View Flat File Contents Using PowerShell
We have all been there; you need to take a look at the data inside a file. Sure you can...
2012-08-07
1,720 reads
Exporting Data Using BCP
BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way...
2012-08-03 (first published: 2012-07-31)
9,022 reads
Color Expressions in SSAS Calculations
Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a...
2012-07-27
1,635 reads
Office 2013 and SharePoint 2013 Beta
If you follow anything outside the regular SQL Server world coming from Microsoft it should be Office and more importantly...
2012-07-17
1,333 reads
PowerPivot for Excel 2013
The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: http://www.microsoft.com/office/preview/en/try-office-preview. Naturally...
2012-07-17
5,254 reads
PowerPivot for Excel Now 2012 Only
I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...
2012-07-17
854 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers