User Group Insights
SQL Server user group members share news, opinions, and tips
[2/12/2009]
- Posted by: Editors
At SQL Server Magazine, we know that SQL Server user group members have a lot to say about their profession! Here's where you can share your thoughts with other user group members, SQL Mag authors and editors, and the SQL Server community at large. Stay...
READ THE ENTIRE POST HERE.
MAKE A COMMENT
|
SQL Server BI
[2/5/2010]
- Posted by: Derek Comingore
Take the Alpha Geek Challenge!The second PowerPivot Alpha Geek Challenge has begun! In challenge #2 (which runs from Feb 4th - Feb 13th), Microsoft's Donald Farmer wants to see your most interesting data set loaded into PowerPivot. Go to the PowerPivot Alpha Geek Challenge website and click on the 'Challenge 2' button to get all of the details directly from Donald himself....
READ THE ENTIRE POST HERE.
MAKE A COMMENT
|
Puzzled by T-SQL
[2/3/2010]
- Posted by: Itzik Ben-Gan
Much has been said already about assignment SELECT statements that perform multi-row variable assignment with an ORDER BY clause. See Paul Nielsen’s blog on the subject as an example. The basic concept is to perform an aggregate calculation in desired order. A very common use of this technique is to perform string concatenation. Consider the following code as an example: DECLARE @s AS VARCHAR(MAX); SET @s = ''; SELECT @s = @s + col2 + ';' FROM dbo.T1 ORDER BY...
READ THE ENTIRE POST HERE.
LAST COMMENT
These lists are often for a child table, where the covering index is likely to be on the foreign key...
ahsimons -February 04, 2010
(Article Rating:  )
|
In a Nutshell
[1/18/2010]
- Posted by: Kevin Kline
I was a little surprised to find that a SQL Server tool I'd just recently heard of, SQLClue v1.4.1.1, was written and supported by an old buddy of mine, Bill Wunder (blog). When I last saw Bill, he and Donald Farmer (blog | twitter | ...
READ THE ENTIRE POST HERE.
LAST COMMENT
Bill Wunder dropped me a note and asked me to post the following added info:
By the way, the SQLC...
Kevin_Kline -January 19, 2010
(Article Rating:  )
|
Industry Bytes
[2/8/2010]
- Posted by: Dan Holme
Here at the Winter Olympics in Vancouver, we’ve applied SharePoint to many business requirements already. On the back end, we’ve again turned to AvePoint for backup and restore functionality—there’s no doubt that we need to have the ability to do granular restore! Their suite of products has gotten much richer, and more complex, since Beijing, but it again proved itself a valuable addition to our toolset—kudos to them. And although I've been working long days here as a Microsoft technology consultant at NBC, I did also manage to get away for a dinner meeting with the...
READ THE ENTIRE POST HERE.
MAKE A COMMENT
|
Developer Connections, Fall 2008
News from the sessions and show floor at SQL Server Magazine Connections, Microsoft ASP.NET Connections, and Visual Studio Connections, November 10-13, 2008
[11/13/2008]
- Posted by: Sheila Molnar
The DevConnections conference has a little-ballyhooed track called DotNetNuke. I sat down with Joe Brinkman, the VP of Core Technology and co-founder of DotNetNuke to find out more about it. Folks at Penton Media, the parent company of SQL Server and Windows IT Pro magazines and windevpro.com are especially interested in DotNetNuke because they're the developing the next generation website for our publications. I wanted to know more about how DotNetNuke blends its open source platform with the Microsoft .NET stack and how developers can take advantage of hooks in the platform to customize their websites. Check out what...
READ THE ENTIRE POST HERE.
MAKE A COMMENT
|
|
| User Group Insights
|
|
FEBRUARY 2010
|
| |
1 |
2 |
3 |
4 |
5 |
6 |
|
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
14 |
15 |
16 |
17 |
18 |
19 |
20 |
|
21 |
22 |
23 |
24 |
25 |
26 |
27 |
|
28 |
| | | | | |
|
|
|
| SQL Server BI
|
|
FEBRUARY 2010
|
| |
1 |
2 |
3 |
4 |
5 |
6 |
|
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
14 |
15 |
16 |
17 |
18 |
19 |
20 |
|
21 |
22 |
23 |
24 |
25 |
26 |
27 |
|
28 |
| | | | | |
|
|
|
| Puzzled by T-SQL
|
|
FEBRUARY 2010
|
| |
1 |
2 |
3 |
4 |
5 |
6 |
|
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
14 |
15 |
16 |
17 |
18 |
19 |
20 |
|
21 |
22 |
23 |
24 |
25 |
26 |
27 |
|
28 |
| | | | | |
|
|
|
| In a Nutshell
|
|
FEBRUARY 2010
|
| |
1 |
2 |
3 |
4 |
5 |
6 |
|
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
14 |
15 |
16 |
17 |
18 |
19 |
20 |
|
21 |
22 |
23 |
24 |
25 |
26 |
27 |
|
28 |
| | | | | |
|
|
|
| Industry Bytes
|
|
FEBRUARY 2010
|
| |
1 |
2 |
3 |
4 |
5 |
6 |
|
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
14 |
15 |
16 |
17 |
18 |
19 |
20 |
|
21 |
22 |
23 |
24 |
25 |
26 |
27 |
|
28 |
| | | | | |
|
|
|
| Developer Connections, Fall 2008
|
|
FEBRUARY 2010
|
| |
1 |
2 |
3 |
4 |
5 |
6 |
|
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
14 |
15 |
16 |
17 |
18 |
19 |
20 |
|
21 |
22 |
23 |
24 |
25 |
26 |
27 |
|
28 |
| | | | | |
|
|
|
|
