(Pinal Dave) Just like any business person, I work with Excel pretty much half of my time when I am not working with SQL Server. Recently I faced challenges when I wanted to extract domain from the email address.
Tag: sql server
Add Database File on Database invloved in DB Mirroring
(Rohit Garg) Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.
Update to ‘The clustered index columns are in all of the non clustered indexes.’
(Kenneth Fisher) I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete.
Sentiment Analysis In Excel With Azure Machine Learning And Power Query
(Chris Webb) You may have seen Joseph Sirosh’s blog post last week about the ability to publish Azure Machine Learning models to the Azure Marketplace, and that MS have published a number of APIs there already. There’s a new Excel add-in that can be used with these APIs but I noticed that at least o
Script to Create Multiple, Same-Sized Tempdb Files
(Larry Leonard) This script will take a tempdb database with one database file, and create a set of equally-sized files. You can set how much total space you want the files to use, and how many files to have (in total).
SQL Server Reporting Services ReportViewer Control for Windows Applications
(Scott Murray) Can I run a SQL Server Reporting Services (SSRS) report from Windows applications? If yes, what are the pro’s and con’s of doing so?
Untrusted Foreign Keys
(Chris Bell) A foreign key is a link between 2 tables that is used to enforce referential integrity in the database.
IDENTITY Crisis
(David Dye) I was recently presented with the task of examining a database, from historic backups, to determine transactions applied over the past 6 years. Unfortunately, the only background/source data available was a few weeks of full backups and, to make this more of a challenge, many conclusion
Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask
(Robert Sheldon) It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren’t obvious that you need to know about, and you feel awkward about asking su
SQL SERVER – What is the Difference Between An INNER JOIN and WHERE Clause
(Pinal Dave) Just received a question in email: “What is the Difference Between An INNER JOIN and WHERE Clause?”