jagbarcelo.blogspot.com
My daily work with SQL Server and Microsoft products.: November 2006
http://jagbarcelo.blogspot.com/2006_11_01_archive.html
My daily work with SQL Server and Microsoft products. A place to know about features, bugs, workarounds, tips and tricks, problems and solutions and server configurations from my day-to-day work (mainly with SQL Server). INNER JOIN with a comma separated values CSV field. K1 List - - - - - - - - - 1 '1, 5, 22, 31' 2 '4, 9, 48' 3 '5, 13, 22'. And you need to generate something like:. K1 Item - - - - - - - - - 1 1 1 5 1 22 1 31 2 4 2 9 2 48 3 5 3 13 3 22. Showed me a solution based on Itzik Ben Gan's.
exutn98.blogspot.com
febrero 2010 | ex U.T.N. - F.R.L.P.
http://exutn98.blogspot.com/2010_02_01_archive.html
Ex UTN. - F.R.L.P. Temas varios, principalmente asociados con las TICs. Conectar ArcGis con SQL Server. Crear una plantilla personalizada en SQL SERVER 20. Cuanto ocupan mis tablas [SQL 2005]. Conectar STATA con SQL SERVER 2005. Jueves, 25 de febrero de 2010. Conectar ArcGis con SQL Server. Lo primero que tienes que hacer es crear una conexión en ArcCatalog contra la fuente a la que quieres conectar. Para ello, abres ArcCatalog y con la parte izquierda de la pantalla navegas a Database Connections. Una v...
awiernik.blogspot.com
Blog de Adolfo Wiernik: agosto 2007
http://awiernik.blogspot.com/2007_08_01_archive.html
Blog de Adolfo Wiernik. Publico informacion sobre mis charlas, libros, preguntas que me hacen y cualquier otro tema de interes en cuanto al desarrollo con Microsoft .NET. Stuck in the 1980s with old-fashioned BIOS. Me he encontrado un comentario que me ha hecho reir y al mismo tiempo despertado mi curiosidad:. EFI es una tecnologia de Intel para sustituir el BIOS. Mas info. Windows Vista efectivamente no soporta EFI en este momento, pero, segun Microsoft lo hara en un posible futuro release. Mas Info.
grumpyolddba.co.uk
Information Links
http://grumpyolddba.co.uk/information_links/information_links.htm
SQL Server Resource for the DBA. The Original Grumpy Old DBA blog. Here's where I go when I'm looking for information or help. Http:/ www.sqlserverfaq.com/. Home is the UK SQL Server user Group. Http:/ www.microsoft.com/sql/default.mspx. Without whom and all that stuff . Http:/ www.sqlskills.com/blogs/paul. Paul should win a prize for the sheer depth and volume of his blog. Http:/ www.snia.org/home. Storage is critical for enterprise systems this is where to start to learn. Itzik Ben-Gan t-sql genius.
ssistalk.com
General » SSIS Talk
http://www.ssistalk.com/category/general
Random thoughts and experiences with SSIS, by Phil Brammer. Using SQL Server Configurations to configure Flat File Connection Manager. Unpack Decimals (COMP-3) from the mainframe. Check to see if a record exists. Dynamic connection for file system task. SCOM 2012 R2 – Specified Cast Is Not Valid Error – Run As Accounts. NOTE: SCOM 2012 R2 Update Rollup 5 addresses this issue. See http:/ support.microsoft.com/kb/3023138. That causes corruption and the following error:. SELECT BME.DisplayName, BME....Well,...
lextonr.wordpress.com
utfNumbers | T-SQL Dev
https://lextonr.wordpress.com/2011/11/22/utfnumbers
Tales of database development. A helpful function borrowed from Itzik Ben-Gan. A table of numbers comes in very handy, especially when it takes virtually no disk space. Create a table-valued function. To use the function, simply select ‘n’ from the function as though it was a regular table, passing in as a parameter the total number of numbers you want returned. The example below will return 100 rows containing one column of values from one to 100. Display content of the function. 22 Nov 2011 at 0022.
thehobt.blogspot.com
The HOBT: June 2009
http://thehobt.blogspot.com/2009_06_01_archive.html
Or There And Back Again. Thursday, June 25, 2009. So You Want To Learn SQL Server Business Intelligence, Eh? So do I. In fact, in Tim Ford’s recent chain blog “Give Me a Coconut and Six Months” ( Tim’s post. Almost all of the bloggers that participated indicated that they’re interested in learning about SQL Server Business Intelligence. I just placed my order for the MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance. Without getting ...